Passing Formula variable data to different Group

[GarouMouko]

Need some help here....

I have a report that groups employees according to Job Code.

After all the records for a JobCode/Employee are read I have a TOTAL WAGE AMOUNT and TOTAL HOURS WORKED....

I then need to add the results to an ACCUMULATION Bucket that holds the result according to breakdown by Hourly Wage = WAGES / HOURS

Example:

LESS THAN $15
BETWEEN $15 and $29.00
BETEEN $30.01 and $49.99
GREATER THAN $50.00


** I can get the DETAIL Amounts for the JobCode/Employee but when I try to Bring the ACCULATED AMOUNT (by dollar category as noted above) either I get $0 or I get the last data element to print...

How can I create an ACCUMULATION Formula that HOLDS TOTALS by Dollar-Range ...and then print these Amounts in the correct Range?

I need a quick turn around on this question if there are any gurus out there!

Thanks.

 

[lbass]

The simplest method might be to group on Employee and insert a crosstab in the group footer. You could use the {@hourlywage} as a row, and click on it, choose group options, and select "specified order." Then enter the range criteria you have noted above.

If you don't want the grid, click on the crosstab->format crosstab->customize style tab->format grid lines and uncheck "show grid lines."

-LB