Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's a slight modification to the formula in the Multi-Row Formula tool that handles ranking ties (this only works if you are not ranking within groups). E.g., instead of ranking: 1, 2, 3, 3, 4, 5, 6, 6, 7, this formula ranks it as: 1, 2, 3, 3, 5, 6, 7, 7, 9
IF [RecordID] = 1 THEN 1
ELSEIF [Row-1:Total Count]=[Total Count] THEN [Row-1:Rank]
ELSE [RecordID]
ENDIF