Equivalent to rank.avg in Excel

[chickenlicken]

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

[estherb47]

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

[RolandSchubert · Accepted solution]

Hi,

it seems a bit complicated, but it does the same as rank.avg

Maybe it's a an approach.

[chickenlicken]

Brilliant, thank you!