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
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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Josh,
      Can you paste in the full text of the error when you go to save the formula?   If we are not able to diagnose the problem that way then I'm happy to have a quick look at your formula tomorrow on a zoom call.

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