Forum Discussion

MJHickey's avatar
MJHickey
Qrew Member
10 years ago

Summarize (count) a numeric field with a condition?

Hello, I have a field that gives a "0" (false) or "5" (true) for "if meets goal". I would now like to be able to summarize how many of the "0" and "5" there are for a specific group or Service Area...
Formulas and functions
reports and charts
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
10 years ago
No problem.
Make a field called [# of 0's] with a formula of
If([Rating]=0,1,0)


Make a field called [# of 5's] with a formula of
If([Rating]=5,1,0)

Then do a summary report and calculate the total of those fields on the report.