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
7 years ago
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
7 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.