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 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
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    If you want a numeric result then you will need to change the field type to be formula numeric.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
  • 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.
    • JoshCollins's avatar
      JoshCollins
      Qrew Assistant Captain
      5 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
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        Josh, what is the field type of your formula field?

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------