I'm trying to create a formula to calculate a prize payout.
I'm getting an error at the end with the parenthesis - it says "Expecting bool, number"
I'm not sure what that means. Is anyone availab...
Forum Discussion
What type of field is your formula field? Numeric? What about the other fields that are used inside your formula, what type are they?
Also you can remove most of those if statements in your formula. You only need the first one. If Quickbase does not get a match in the first part of your formula it continue down the line to the next part. It finishes when it finds the first match and does not continue further. So if Condition 1 was correct it wouldn't even bother checking condition 2 in the below formula, if condition 1 was incorrect it would continue to condition 2.
If(
[Condition 1] = "whatever", "do this",
[Condition 2] = "something else", "do that"
)
Also you can remove most of those if statements in your formula. You only need the first one. If Quickbase does not get a match in the first part of your formula it continue down the line to the next part. It finishes when it finds the first match and does not continue further. So if Condition 1 was correct it wouldn't even bother checking condition 2 in the below formula, if condition 1 was incorrect it would continue to condition 2.
If(
[Condition 1] = "whatever", "do this",
[Condition 2] = "something else", "do that"
)
# OF PLAYERS FOR EVENT IS NUMERIC
PLACE IS TEXT MULTIPLE-CHOICE - IS THIS THE ISSUE?
THE EVENT PRIZE POOL IS CURRENCY
PLAYER PRIZE PAYOUT IS FORMULA-NUMERIC​
------------------------------
Renee Hansen
------------------------------
PLACE IS TEXT MULTIPLE-CHOICE - IS THIS THE ISSUE?
THE EVENT PRIZE POOL IS CURRENCY
PLAYER PRIZE PAYOUT IS FORMULA-NUMERIC​
------------------------------
Renee Hansen
------------------------------