Forum Discussion

Chrisjr's avatar
Chrisjr
Icon for Helper IV rankHelper IV
2 years ago

Rankx with ties

Hello All,    I have a ranking issue I can't solve.    I have the below table:  1 same group can have multiple dealers.    My ranking formula is  the following:  ranking test = IF(NOT ...
"RANKX"
talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi Chrisjr 

 

Please try something like this, correct the table/column names. If it doesn't work, please share sample data, few rows from tables involved in this visual(remove any sensitive information).

RANK( DENSE, ALLSELECTED(Lookup__Dealer), ORDERBY( [Score in %], DESC))