Top 10 Percent 1

[sopomeres]

CR8.5: I have a list of employees with salaries. How can I display employees with the top ten percent salaries.

Thanks.
Chuck

 

[lbass]

Sort by the salary field, descending, and then go to the section expert->details->suppress->x+2 and enter:

recordnumber > count({table.field})*.1 //use a recurring field

-LB

 

[sopomeres]

LB,

It works for a straight list with no grouping. Now how do you apply this so it shows the top ten percent for each job group in a report?

Thanks for the help!
Chuck

 

[lbass]

Create a running total {#cntwingrp} where you choose a recurring field, count, evaluate for each record, reset on change of group. Then change the suppression formula to:

{#cntwingrp} > count({table.field},{table.group}) * .1

-LB