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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

Quasar

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

Highlighted
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