Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this expression.
= if(score=max(score),Customer) &'::'&max(score)
Or
=Aggr(if(rank(max(score))=1,Customer),Customer)&':'&max(score)
Thanks,
Muni
Try this
Customer = p({<score={$(=max(score)-1)}>} Customer)
I don't know what p is and it's not a good expression when I plug it in.
P = Possible (are slected)
See this manual for SET ANALYSIS
Hi,
Try this expression.
= if(score=max(score),Customer) &'::'&max(score)
Or
=Aggr(if(rank(max(score))=1,Customer),Customer)&':'&max(score)
Thanks,
Muni
Thank you so much!
Hi ,
You got result means mark it correct answer. It will helpful for others.
Thanks,
Muni