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
------------------------------
Original Message:
Sent: 09-16-2020 16:04
From: Austin K
Subject: Can I use an "if" formula with numeric fields?
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.
Original Message:
Sent: 09-16-2020 15:24
From: Josh Collins
Subject: 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
------------------------------