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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Is the result to be s number or a true /false result?

    Can you explain the he logic for when it should �count�?
  • AnnSwelgin's avatar
    AnnSwelgin
    Qrew Trainee
    7 years ago
    I believe it would be true/false, so whether it has either of these activity types or not.

    This is the original formula:
    If(Contains([Activity Type],
    "PDFA",1,
    "PDAFA",1,
    null)

    I found this report someone else had created a few years ago and I am still learning what this table actually does.. I'll do some deeper digging and see if I can fix on my own or ask again. 
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Ok. Now I understand

    Contains([Activity Type], �PDFA")
    OR
    Contains([Activity Type],�PDAFA")
  • AnnSwelgin's avatar
    AnnSwelgin
    Qrew Trainee
    7 years ago
    Yep but when I put the OR in instead of the comma it give me another error
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Can you post your exact formula and the error message. I�m not able to see any syntax errors in my formula.

    Note that my formula was meant to replace yours.
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    7 years ago
    I had a similar case where after adding an 'OR' condition the formula error checker told me it was expecting a comma, but I saved the field and when I went back in to evaluate it the error was gone and the formula was working fine.

    After starting to write this response I thought I would check again and sure enough by going back into the same formula and overwriting 'or' with 'OR' i get the same error stating it is expecting a comma. When I saved it the first time it changed the CAPS version of 'OR' to lowercase 'or' and worked fine. Seems like a bug.