Difference between the Top Performer and rest

[renjithpl]

Hi All,

I want to find out the difference between the Top Performer and the rest of the User,

This is my straight table

User	Documents Reviewed	Hours	Productivity	Differrence
Marshal	65	6.5	10.00	?
Lloyd	1507	96.5	15.62	?
Bendict	1232	89	13.84	?
Rachel	600	32	18.75	?

To get the Productivity the expression is =Sum([Documents Reviewed]) / Sum(Hours),

So Rachel has the top Productivity (18.75), In my Difference Column i want a formula, that should calculate like below:

Marshal - (18.75 - 10.00 ) ans: 8.75
Llyod - (18.75 - 15.62) ans: 3.13
Bendict - (18.75 - 13.84) ans: 4.91
Rachel - (18.75 - 18.75) ans: 0.00

Thanks in advance

Ranjit

[lironbaram · Accepted solution]

hei

attcah is an example of what you asked for

i added a variable which calculate the best score diregarding selections in user filed

hope it helps you

[matt_crowther]

Ranjit,

Attached is an alternate solution to that in the previous post that may be a little bit more flexible (Both will work & the variable solution is a good one).

I've used the top() function to refer to the highest scoring individual allowing for the calculation to be carried out entirely within the object.

Hope that helps,

Matt - Visual Analytics Ltd

[renjithpl]

Thank you guys for your help. 🙂

[renjithpl]

PFA

[renjithpl]

Hi Roi, when i tested first it worked for me, but can you see my latest attachement, please tell me what is wrong it that formula. I have made exactly what you said.

Thanks

[Anonymous]

You forgot to add the Variable

Ctrl + Alt + v

Add: MaxProdctivtiy

Definition:
=max({<User=>}aggr(sum({<User=>}DocumentReviews)/Sum ({<User=>}Hours),User))

That should work.

[renjithpl]

yes yes... i forgot thanks a lot...