AnsweredAssumed Answered

Checkbox Calculation

Question asked by JoshuaGagnon on Sep 15, 2014
Latest reply on Sep 15, 2014 by philmodjunk


Checkbox Calculation


Thanks to PhilModJunk I was able to solve my calculation needing a field to return a "1" if a checkbox is selected:

Not IsEmpty ( FilterValues ( YourCheckBoxField ; "Hispanic or Latino" ) )

returns the value 1 if the check box for Hispanic or Latino has been selected.


However, I realized that I marked the post resolved too quickly! It works perfectly if the checkbox is selected the value returned is 1. However, it's default status is "0" for not selected. Is there a way to make the default of the box "2" for not selected and then switch to "1" when selected? Thanks again in advance!