Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So I've created a table, where I display the rank of the company (COMPANYNAME) by sum(PARHELD).
In places where the sum(PARHELD) is the exact same, the rank is set as the same for both companies (example below: 16-17 is the rank for 2 different companies).
Is there a setting I can change which sets the rank as a unique value? So that one company is rank 16, and the other is rank 17?
Right now the expression for this column is: Rank(Sum(PARHELD)/1000000)
Thanks!
Hi there,
Yes, there is. The Rank() function accepts an optional second parameter that defines what to do when the values are exactly the same. The complete list is described in the Help section, however I believe you need to use the number 4 to get a sequence of unique numbers:
Rank(sum(Value), 4)
Cheers,
Oleg Troyansky
Try this
Rank(Sum(PARHELD)/1000000, 4, 1)
Or
Rank(Sum(PARHELD)/1000000, 4)