Nov 16, 2024 10:52 PM
Hello, hope you are all doing well.
Need some help giving points to each participant per race result, would like to create a field on the same table with a formula that does that automatically.
The point system is basically the reverse order of the number of participants, ea: 1st place gets the total number of participants in points, the 2nd place gets one less, and so on, with last place getting 1 point
Here is the condition, only the "Pos" with numbers will get assign the points. Positions that have a DNF or DNS will get just 1 point
Here is the table:
Any help will be grateful, my brain is toast for the night, trying all kinds of ways.
This might be super simple for someone out there 😆
Thank you!
Nov 17, 2024 12:05 AM
Hm so there are multiple races, right? If so, I think you're going to need:
1. Races: table where each record represents one race
2. People: table where each record represents one person
Let's call your main table "Data"
You'd then link everything up accordingly, which would allow you to create a Count field in the Races table that'll give you the total number of participants for that race. You could then use a lookup to pull that Count field into the Data table, and you'd use a formula that would help you output the points for each person based on:
1. Their position in the race
2. The total number of participants in that race
Once you output those points, you can create a rollup field in People on that new points field, which would give you each persons total from all their races
Nov 17, 2024 02:38 AM
Hi,
Is it correct that number of participants 11 here? And Pos1 gets 11 pts, Pos2=10 pts, Pos#6 gets 6 points, the rest (Pos 7-11) are 1 pts.
Your formula will be
1+IF(VALUE(Pos),11-VALUE(Pos))
if you have different total number each race, to count total, you need to link and do the stuff according to @TheTimeSavingCo instructions
Nov 17, 2024 04:57 PM
Thank you guys, will get working on this 😀. @Alexey_Gusev already applied that formula, thank you man. @TheTimeSavingCo will work on those tables tonight. Thank you all again