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.
  • 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
      ------------------------------
      • JoshCollins's avatar
        JoshCollins
        Qrew Assistant Captain
        5 years ago
        Hey Mark, it is a "Formula - Currency" field.

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