Rank function

[#1]

Hi guys,

I just wanted to ask if I wanted to rank an expression but in this scenario a lower number should be ranked higher than a higher number.

So if the set consisted of {3, 6, 8,} then 3 should be ranked as the 1st,  6 should be ranked as 2nd and 8 should be ranked as 3rd. Is there a provision for this option in the rank function?

Regards

[Gysbert_Wassenaar · Accepted solution]

Use rank( -1* Value) instead of rank(Value)

or rank(-Value) or -rank(Value)

[CELAMBARASAN]

Hi,

You can achieve this by adding - ve sign before it

Use Rank(-FieldName) or Rank(-Sum(FieldName))

Hope it helps

Celambarasan

[#4]

Yeah of course. Stupid question