cancel
Showing results for 
Search instead for 
Did you mean: 

Rank Function

It would be great to have a Rank function.  This would allow for sorting by rank of values in tables/galleries.  For example, creating a scorecard (e.g. for golf tournament, team ranking, etc.) is simple to sort by scores, but you can't include the teams'/players' ranking among all of the teams/players/etc..

Status: New
Comments
bgergoe
New Member

AddColumns(

RenameColumns(

Sequence(

CountRows(YourTable),
1,
1

),

"Value",

"Rank"

),
"RealID",
Last(

FirstN(

Sort(

YourTable,
NumericColumn,
Ascending

),
Rank

)

).NumericColumn

)