community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Equivalent to rank.avg in Excel

Alteryx Partner

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

Pulsar
Pulsar

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

Alteryx Certified Partner
Alteryx Certified Partner

Hi,

 

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

Maybe it's a an approach.

 

 

Alteryx Partner

Brilliant, thank you!

Labels