Apply Formula to TopN in group

[elead]

I am looking for a way to single out a TopN of records within a group and apply a formula to them.

I have one group and a sum of records for each employee in the group footer

I need to apply a bonus of 'XX' to the top 5 employees

thanks

 

[dgillz]

You could make your top N based on sales and then create a formula off of the summary by sales. EG - Sum({sales},{employee})*.05 would calculate a 5% bonus.

If you need help creating a top N report let me know. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[elead]

Actually, I have 80 employees. I want all 80 on the report but only want to apply a $10 bonus to the top 5 with the highest count of xx in the footer...does that make sense??

thanks

 

[dgillz]

Sort the report in descending value of teh group (I'm sure you've already done that) then insert a running total count, evaluate on change of group-employee, reset=never. This will simply "number" your employees from 1 to 80 on whatever it is they are being measured on.

Then create a @bonus formula and put it in the employee group footer:

If {#count}<= 5 then 10 else 0

Let me know if you have problems. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[elead]

dgillz,
thanks for all the help thus far but I am getting nowhere. How about if I save the report with the data and send it to you that way you can see what I'm doing wrong?

thanks

 

[dgillz]

Sure bring it on. Dgilsdorf@altavista.com Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office