FirstSortedValue

[Karim_Khan]

Hi Team,

    I was making the scenario for FirstSortedValue() function.I am littele bit confused about '-' symbol.It will give the max value or min value.

Regards,

KK

[sunny_talwar · Accepted solution]

If you use it in a chart like the way you have used it, you will see all the values. It will essentially work the same way as Only() function. But if you use this in text box object, you will see difference. -Salary will show the Name associated with the person having the maximum salary, where as Salary will show the Name associated with the person with lowest salary

[miguelbraga]

Hi Karim,

The symbol '-' gives you the max value. Just delete that symbol, and you'll get the min value

Regards,

MB

[MK_QSL]

Use

firstsortedvalue(Distinct Name,-Salary)

[Karim_Khan]

Thanks for always helping