Forum Discussion
RANKX Problem
I have been using the following formula with RANKX successfully with various tables, but I'm running into an issues where different values get the same rank with the following report: G - Rank = ...
You have 11 different values, but the measure only returns ranks of 1 to 3. What is your intention ?
I'm sorry, I thought my intention was obvious...
I would like "G - Rank" to contain the ranks from 1 to 11 based on the values of G.
So G=62 would have G-Rank=1
G=44 would have G-Rank=2
G=37 would have G-Rank=3
...
Thanks, MT