Need formula help please.
How do I use the %s shown in the referenced table as a multiplier in the Place Payout fields? I don't want to go back to the referenced table since I need to use the %s shown in the referenced record. I have many other records in the referenced table.
6 replies
-
FYI. The individual 1st Place %, 2nd Place %, etc fields will be deleted.
-
what does the data look like in the '1st Place %' field?
do you have an example of the code you are trying to use?
-
The referenced table date looks like this. I created 6 records so far, each has one more payout so the percentages change in each record:
-
You probably have a field that tracks total pot (totalPot), so it could be something like:
totalPot * Payouts.'1st Place %'
or if you have some code that you have tried please post that.
-
I posted of the FB Ninox page too, and you can see more of my code there. Please look there:
-
I think I may have it based on your suggestion. I am testing. This is what it looks like and it does seem to calculate correctly:
'Total Prize Pool' * number('Payouts Linked'.'1st Place %') / 100
Content aside
- 3 yrs agoLast active
- 6Replies
- 350Views