Total in Group and then Report Footer 1

[rwn]

I'm using these two formula's to obtain a total in the footer. Which works fine. I need to also have a Group total for each @sharedlaborcost Grouping.

whileprintingrecords;
shared numbervar x:= {@sharedlaborcosts};
numbervar sumx := sumx + x;

whileprintingrecords;
numbervar sumx;

 

[lbass]

Change the accumulation formula to:

whileprintingrecords;
shared numbervar x:= {@sharedlaborcosts};
numbervar groupsum := groupsum + x;
numbervar sumx := sumx + x;

Then add a reset formula in the group header:

whileprintingrecords;
numbervar groupsum;
if not inrepeatedgroupheader then
groupsum := 0;

Add a display formula to the group footer:
whileprintingrecords;
numbervar groupsum;

-LB

 

[rwn]

Thanks, you are the best!