Crystal XI R2 on a Progress Database (Epicor Vantage). Want to sum a group

[Former Member]

Using Crystal XI R2 on a Progress Database (Epicor Vantage). Want to sum a group...

I have a sum of production hours grouped by production job hrs. set to average. (Group 1)

I want to sum these group totals and display them in Group 2 for the Est. and Act. fields ( if I just sum them I get all of the deatil records too and that is too big a number...

Page 3 of 3

Job: T4-60020

Seq Date Employee Name Labor Hrs Labor Qty Scrap Qty NonCnf Qty Est. Prod Hrs Act. Prod Hrs Est. Setup Hrs Act. Setup Hrs

Detail - 200 10/14/2011 Lawrence B. Babay 2.00 0.00 0.00 0.00 2.00 5.50 0.00 0.00

200 10/17/2011 Lawrence B. Babay 3.50 0.00 0.00 0.00

Group 1 Sum Seq 200 Total 5.50 0.00 0.00 0.00 2.00 5.50 0.00 0.00

Group 2 Job:T4-60020 Total 168.44 0.00 0.00 0.00

[Former Member]

Hi

You will have to write a running total to get this summary :

Write two formulas to get this :

@formula1 // Place this formula in your report group where you have average field

Whileprintingrecords;

Numbervar x;

x:=x+youraverage total;

@formula2 // place this where you want to display sum of your average.

Whileprintingrecords;

Numbervar x;

Thanks,

Sastry