Discussions

 View Only
  • 1.  Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 15:24
    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
    ------------------------------


  • 2.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 15:55
    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
    ------------------------------



  • 3.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 16:05
    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.


  • 4.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 16:19
    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
    ------------------------------



  • 5.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 19:26
    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
    ------------------------------



  • 6.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 19:39
    Hey Mark, it is a "Formula - Currency" field.

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



  • 7.  RE: Can I use an "if" formula with numeric fields?

    Posted 09-16-2020 22:48
    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
    ------------------------------