Sorting repeating groups in mobile beta

I’m looking to get some help. I’m struggling to understand how I can sort the attached table.

I’m using Short List in the mobile beta and the data source is user. The scores of each user, games, wins, losses, win% are all Do a search for GamesPlayed, constrained to current item user. The Win% is counting current items wins/played formatted as a percentage. How do I get it to sort via Win % to get those with the highest percentage at the top of the table?

First to sort by a value, the record must be in the DB, then you can sort by it’s value…
You can try Saving it in the DB then sort by it…

I mean win/played *100, then have it save in the DB and sort by it

Ah I was worried that might be the answer. I’ll have to add it to the database and follow your advice. Thank you.

I wonder if it’s worth freshly calculating the things I need as the app loads each time. Rather than on the fly.