on 10-25-2011 2:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.