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
------------------------------- MarkShnier__You
Qrew Legend
I also suggest that tyou not nest your IFs, but yes, among the problems that the formula may have is that if the [Place] is a text field, then you will need to test like this
[Place]="1"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------Ok changing the [place]="1" worked, however, I'm still getting the "expecting book, number" error at the end with the first parenthesis.
and I don't know what "nesting the IF's" means :)
Floor(If([# OF PLAYERS FOR EVENT 06-19]<=4 and [Place]="1",([EVENT - PRIZE POOL 06-19]*0.6),
If([# OF PLAYERS FOR EVENT 06-19]<=4 and [Place]="2", ([EVENT - PRIZE POOL 06-19]*0.4),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19] >=5 and [Place]="1",([EVENT - PRIZE POOL 06-19]*0.4),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19] >=5 and [Place]="2",([EVENT - PRIZE POOL 06-19]*0.3),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19]>=5 and [Place]="3",([EVENT - PRIZE POOL 06-19]*0.2),
If([# OF PLAYERS FOR EVENT 06-19]<=10 and [# OF PLAYERS FOR EVENT 06-19]>=5 and [Place]="4",([EVENT - PRIZE POOL 06-19]*0.1),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]="1",([EVENT - PRIZE POOL 06-19]*0.3),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]="2",([EVENT - PRIZE POOL 06-19]*0.25),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]="3",([EVENT - PRIZE POOL 06-19]*0.2),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]="4",([EVENT - PRIZE POOL 06-19]*0.15),
If([# OF PLAYERS FOR EVENT 06-19]<=15 and [# OF PLAYERS FOR EVENT 06-19] >=11 and [Place]="5",([EVENT - PRIZE POOL 06-19]*0.1),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]="1",([EVENT - PRIZE POOL 06-19]*0.29),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]="2",([EVENT - PRIZE POOL 06-19]*0.24),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]="3",([EVENT - PRIZE POOL 06-19]*0.19),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19]>=16 and [Place]="4",([EVENT - PRIZE POOL 06-19]*0.14),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]="5",([EVENT - PRIZE POOL 06-19]*0.09),
If([# OF PLAYERS FOR EVENT 06-19]<=20 and [# OF PLAYERS FOR EVENT 06-19] >=16 and [Place]="6",([EVENT - PRIZE POOL 06-19]*0.05),
)))))))))))))))))))))))
------------------------------
Renee Hansen
------------------------------
