Adding Totals in Detail 1

[kuberacupidagra]

Hello All,

I am using CR10 and have two Groups in the report.

Group #1: Departments.Dept (Values: 603, 632, 653 etc)
Formula: AMNT_Dec_Dept_Sum = Sum ({@AMNT_Dec},{DEPARTMENTS.DEPT})

Group #2: Overheads.Overhead_Type(Values:OH Dollars Fringe, OH Dollars Labor, OH Dollars NonLabor)
Formula: @AMNT_Dec_OH_Sum = Sum ({@AMNT_Dec}, (OVERHEADS.OVERHEAD_TYPE})

Within Group #2 (OH Dollars Fringe, OH Dollar Labor) etc. there are several records in the Detail Section of the report:

Example Within OH Dollars Fringe:

(TTFGLD.Desc) field T_LEAC @Amnt_Dec
Sick Leave 9103-000 1370
Holiday 9102-000 1000
Vacation Pay 9101-000 800
Medical 9104-000 1500
Sick Leave 9103-000 590
Holiday 9102-000 750
Medical 9104-000 1000
Vacation Pay 9101-000 1200

There are over 200 T_LEAC categories.

How can I add up values for Sick Leave, Holiday, Vacation etc in the Detail Section and show as Total for that item instead of showing duplicates.

Thanks for your help.

AA

 

[synapsevampire]

One means might be to group again by T_LEAC, and show the sums in the group footer, then just suppress the details.

Does that resolve?

-k

 

[kuberacupidagra]

Hello synapsevampire,

THANKS for your solution. It is resolved.

Happy Holidays,

AA