Forum Discussion

JoshCollins's avatar
JoshCollins
Qrew Assistant Captain
6 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 understand how to write the formula to fix it.

Here is the formula:

IF (([Numeric field #1] - [Numeric field #2] + [Numeric field #3]) > ([Numeric field #1] * 0.25), ([Numeric field #1] * 0.25), ([Numeric field #1] - [Numeric field #2] + [Numeric field #3]))​

Any help you could provide would be greatly appreciated!

------------------------------
Josh Collins
------------------------------
Formulas and functions

6 Replies

  • AustinK's avatar
    AustinK
    Qrew Commander
    6 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.
    • JoshCollins's avatar
      JoshCollins
      Qrew Assistant Captain
      6 years ago
      Hey Austin, thanks for the reply. 

      You're correct, I didn't accurately give you the field type.

      Numeric Field #1 is actually "Formula - Currency"
      Numeric Field #2 is actually "Formula - Currency"
      Numeric Field #3 is actually "Currency"

      Would it be as easy as changing these to the type "Formula - Numeric" and "Numeric" and then just displaying the result as currency instead of simple number?

      Thanks!​

      ------------------------------
      Josh Collins
      ------------------------------