Solved: Assign Rank/Position (Competitions) - Page 2

juanpa · 09-08-2020 04:10 PM

Hi! I have a list of dancers in my app. My users (judges) often give scores to them on different attributes. In the end, the sum of those scores is made (I have a virtual SUM Total Column) and the one with the highest score wins. Is it possible in AppSheet to use the SUM Total and automatically assign the rank/position of the dancer? If yes, is also possible to give the same position to two different dancers if they have the same punctuation?. Thank you!

Koichi_Tsuji

In this case, I do employ different technique and approaches for “ranking” stuffs.

The issue is how to deal with ranking when we have the same score. Further more there will be two different requirement in terms of numbering for duplicates.

1, 2, 3, 3, 5, 6 …
or
1, 2, 4, 4, 5, 6…

Either way, the expression will returns what we need.

I generated quick sample.
This is just a matter of math.

View solution in original post