Forum Discussion

JohnDonnelly's avatar
JohnDonnelly
Qrew Trainee
6 years ago

Formula to Count Total # of Fields the are Checked

Is there a formula that can help me count the total number of checkbox fields that are checked/positive?  I have 12-15 Checkbox fields in a particular table, and I'd like to identify the total/sum tha...
Formulas and functions
SteveHanson's avatar
SteveHanson
Qrew Trainee
6 years ago
It took me a minute to figure out why this wasn't working; I had to select the formula under Columns to Display, and change formula from Tex to Numeric. This was handy to get the total within each record to display at the end of the record row, but how do I get the report to total each column?

------------------------------
Steve Hanson
------------------------------
SteveHanson's avatar
SteveHanson
Qrew Trainee
5 years ago
Another rookie mistake. It turns out what I was looking for was already built-in. In the field settings, under Checkbox field options I clicked Show a "totals" row in reports. This then produced a row at the bottom totaling up all the checkboxes for each column of my report. 



------------------------------
Steve Hanson
------------------------------