Forum Discussion

JanaBaker's avatar
JanaBaker
Qrew Cadet
7 years ago

Nested If Formula Error: Expecting Boolean but found number

Hey everybody!  Can someone help me with the below formula?  I get the "expecting Boolean but found number" error at the end of the FIRST If statement.  If i change it to NULL, then the 2nd IF stateme...
Errors
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
Aside from the syntax error, it is an odd looking formula, can you explain in words what the logic is trying to do?
AnnSwelgin's avatar
AnnSwelgin
Qrew Trainee
6 years ago
It is within a bar chart report. basically if the activity type is either of those it would count 1 and if not those type then it doesn't count it.