Summary for checkbox field

[Chad Crawford]

I have a checkbox field with 3 choices in it ("Math", "Science", and "GLOBE"). I want to get a summary of how many records in a found set have a particular choice selected. Some records have more than one choice selected, so I would want that to be reflected in the summary for each choice. How would I do this?

[mr_vodka]

You could create 3 calculation fields with something like Case ( field = "Math"; 1 ), and then use a summary field to add each of those totals...

OR, you can just get rid to the original field all together and use just the three fields with a single boolean valuelist checkbox.

This is usually what I use, and LaRetta has graciously provided a write up on it already. She always makes my life easier because instead of me having to type everything out again, usually she has great thorough posts that I can just easily reference.

LaRetta's post regarding boolean checkboxes

[Søren Dyhr]

You could create 3 calculation fields with something like Case ( field = "Math"; 1 )

This is too hasty a suggestion, because of the very nature a field with several checked boxes checked, exhibits the check-order the user entered them... should instead be:

Sign(PatternCount("Math";field))

...but still one fore each box availiable though!

--sd