I am trying to create the equivalent of the Rank.avg formula.
I have used the Sort tool followed by the Multi-Row formula in order to create rankings for sub-groups. This is fine where I use the simple expression [Row-1:Rank High]+1
I have got as far as this, but this doesn't quite get there. Is this something I can do within the formula of the Multi-row tool?
IF ([Value]!=[Row-1:Value])
THEN ([Row-1:Rank High]+1)
ELSE [Row-1:Rank High]
ENDIF
Solved! Go to Solution.
Hi @chickenlicken,
Would you post some sample data so that we can see what you're trying to do?
As far as using the MultiRow formula tool, are you using any sort of a grouping level? That can help a lot with ranking.
Also, quickly double-check that the "Values for Rows that don't Exist" is set to "0 or Empty"
Cheers!
Esther
Brilliant, thank you!