Max function

[Anonymous]

Hi, I have created a text object that displays Max([Score]).  I get the highest score, but I want to also display the name who received the highest score.  How do I add an expression to say give me the name of the person who scored max([score])?  Thank you.

[ecolomer]

Try this

Customer = p({<score={$(=max(score)-1)}>} Customer)

[Anonymous]

I don't know what p is and it's not a good expression when I plug it in. 

[ecolomer]

P = Possible (are slected)

See this manual for SET ANALYSIS

[muniyandi · Accepted solution]

Hi,

Try this expression.

= if(score=max(score),Customer) &'::'&max(score)

Or

=Aggr(if(rank(max(score))=1,Customer),Customer)&':'&max(score)

Thanks,

Muni

[Anonymous]

Thank you so much!

[muniyandi]

Hi ,

You got result means mark it correct answer. It will helpful for others.

Thanks,

Muni