Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thank you guys for your help. 🙂
PFA
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
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.
yes yes... i forgot thanks a lot...