AnsweredAssumed Answered

Checkbox Value list has error make it 1 (should be 0)

Question asked by user17311 on Jul 20, 2018
Latest reply on Jul 20, 2018 by philmodjunk

I have a set of 4 checkboxes that is linked to 4 Value fields. Originally this was working fine but for some reason, it now automatically has a value of 1 putting my calculations out.

 

The field itself has a default value of 0 in the Tables field options of auto-enter Data

 

The calculation is that when 1 checkbox is checked it has a value of 1, 2 checkboxes it is 2 and so on. There is an additional field that if selected also adds an additional value to the calculation as well.

 

If ( ValueCount ( area ) = 1; 25 + RemoveClippingsPrice ; If ( ValueCount ( area ) = 2; 30 + RemoveClippingsPrice ; If ( IsEmpty ( area ); 0 ; 35 + RemoveClippingsPrice) ))

 

RemoveClippingPrice Field Calculation

If ( RemoveClippings = "Yes"; 5 ; 0 )

 

So when nothing is selected it should be a value of 0 however it is currently 25,

Outcomes