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,