Forum Discussion

JoshCollins's avatar
JoshCollins
Qrew Assistant Captain
5 years ago

Can I use an "if" formula with numeric fields?

Hello, I am trying to use an "if" statement for a formula in a Formula - Numeric field.  I am getting the error: "Expecting bool but found number." I understand what that means, but I don't underst...
Formulas and functions
AustinK's avatar
AustinK
Qrew Commander
5 years ago
Without changing anything in your formula it worked for me. When I copied it over it did have a weird red highlighted character at the end but I just deleted that, you may or may not have that in yours.

Are you positive these are Numeric fields(not Numeric - Currency, Numeric - Percent, etc) and that you are working with a Numeric Formula field? It sounds kind of like it may be a Formula Checkbox.