Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use rank to display the lowest values, but no matter what I use in the 2nd parameter, the result is the same. I'm using v9 sr3.
Can you give us an example of the 'wrong' results? Steps to repro? your expected result?
We need more detail before we can help.
The wrong result is that Rank(x,1)=1 is the highest value, not the lowest.
I'll upload a QVW to reproduce the error.
In fact, the rank function return a dual format number.
To see the result of changing the 2nd parameter, you need to use =num(rank(var,1)