1 Reply Latest reply on May 15, 2013 2:47 PM by philmodjunk

    Calculation - Count of "Other" Checkbox  Values



      Calculation - Count of "Other" Checkbox  Values


           Hi All,

           I have a field that consists of five checkboxes.  Four are defined, the fifth is the "Allow entry of other values" option.  How can I get the total count of database records that have a value in the "other" check box.

           Thanks for any help you can provide.


        • 1. Re: Calculation - Count of "Other" Checkbox  Values

               Define a calculation field in your table as:

               If ( IsEmpty ( FilterValues ( ValueListItems ( Get ( FileName ) ; "YourValueListNameinQuotesHere" ) ; YourCheckboxFieldHere ) ) ; "Other" )

               Select Text as the result type.

               There are then several different ways that you can count all records where this calculation field returns "Other". Which method you can use, depends on the version of Filemaker and the context in which you want to get that count.