Rank of Dimension

[jdmarlin]

I have a dimension, 'n', with values ranging from 0 - 10. I want to show the rank of 'n' in text boxes based on the selections I make.

So if the possible values of 'n' are 3, 5, and 7 then I want to show:

Rank of 3: 1

Rank of 5: 2

Rank of 7: 3

[Nicole-Smith]

An expression like the following should do the trick:

match(7, $(=concat(distinct n, ', ', n)))

You would just replace the 7 with whatever number you're looking to rank.

I've also attached a sample file.