1 Reply Latest reply on Sep 15, 2014 12:02 PM by philmodjunk

    Checkbox Calculation

    JoshuaGagnon

      Title

      Checkbox Calculation

      Post

      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!