calculating the best 25% employees

[MissReportNet]

Hi all,

I have to calculate a standard which is the lowest number roundup of the best 25% employees. example. 25% of the best is 7,5 which makes the standard 8.
Employee Numbers done
A 10
B 9
C 8
D 7
E 6
F 5
G 4
H 3
I 2
J 1

Hope you can help me out of this.

Thx in advance,

MissReportNet

 

[JDAEMS]

Hi MissReportNet,

Do you mean that you want the following: In your table you have 10 customers and you want the best 25% checked on the numbers done. So the result you are expecting is Customer A, B and C.

I think that you want the following:
- max(numbers done) - (max(numbers Done) * 0,25)
e.g: 10 - ( 10 * 0,25)
- to round this number, use one of the possible functions.
- Make a filter in which you say that Numbers Done has to be equal or more than the number you get back from that calculation.

I hope this helps a little bit.

 

[JPCogAdmin]

Missreportnet,

Your question is hardly understandable.
Try clarifying it and you may get more results.


-J