January 31, 200718 yr Newbies 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?
January 31, 200718 yr 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
February 1, 200718 yr 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
Create an account or sign in to comment