RANKEQ

iamakbarilham

i try to ranking the number column with some criteria with this formula:

=IF(AND(HAS([Product Category]:[Product Category]; "Google"); OR([Stage Category]@row = "Healthy"; [Stage Category]@row = "Stuck")); RANKEQ([Sum of Total Contract Value (converted)]@row; [Sum of Total Contract Value (converted)]:[Sum of Total Contract Value (converted)]; 0))

but when i check the top 30 ranking with filter, i just find this rank. please help:

Christian G.

You "IF" only prevent the RankEQ to write something in the column. But you rank all the row. It happens that 22,23 and 24 fit the "if" condition.

You could set a helper column that flags the rows you want to rank, and then rank on that column

[Helper column] : Checkbox

=IF(AND(HAS([Product Category]:[Product Category]; "Google"); OR([Stage Category]@row = "Healthy"; [Stage Category]@row = "Stuck")); 1; 0))

[Ranked TCV]:

=RANKEQ([Sum of Total Contract Value (converted)]@row;collect([Sum of Total Contract Value (converted)]:[Sum of Total Contract Value (converted)];[Helper column],=1))