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
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago
Use ToNumber to turn the true value of a checkbox to the number 1:


Sum(
ToNumber([field1]),
....,
ToNumber([fieldn])
)


...Just saw Mark's post and that is valid too.

------------------------------
Adam Keever
------------------------------