Another report question - tallying checkboxes in a report

Question

Hi all!Looking for ideas on how to draft a report that will tally how many records have more than one checkbox checked (of a series of defined checkboxes). Please and thank you in advance!

MarkShnierYou · Answer

I think your best bet is to make a helper feel to add up the number of check boxes with your check. I think you can simply use the SUM function and list all your fields. The SUM function should work on checkbox fields.

Then you can use that field in your report as a filter or a column

Sign up

Login to the community