Rank Function

[#1]

Hi Everyone,

I am working on selecting the highest performer in a certain type of sport. So, I need my text object to return a name for the highest number of scores, and currently the expression is

= only({<Sportsman={"=rank(sum([Total Number of Points Scored], Sportsman)=2"}>} Sportsman),however it doesn't work and only returns a '-'. Can anyone help with this please?

Thank you,

Anna

[#2]

that doesn't seem quite to work. So, with the formula provided for the first one, if there is a 2, then it doesn't give the highest, but lists all second highest, so I changed it to 1 and it works., For the lowest one- 2,3 etc don't work..

[tresB]

Did you notice the '-'symbol I used before sum() function for lowest rank? It should work. Otherwise try to share a sample app.

[#4]

I did notice the symbol, however, I can't share the app. It seems to return second highest values.