Highest scores for players

Ask for Help
1

I am brand new to Glide and trying to create an app capturing the best 5 golf scores from the last 10 rounds of each player but I can’t seem to do this. If I create an array and then slice this at top 5 you can’t do a sum of it as it gets converted to text.

Can anyone suggest how this can be done? Essentially I want to do the equivalent of excel function =SUM(LARGE(A1:A10,{1,2,3,4,5})).

2

I would create a query, sort it appropriately by score, and limit it to 5 results. Then do a roll-up against that query. This is assuming each score is in individual rows.

1 Like