Sum Grouped Values 1

[mmck1964]

I am trying to sum grouped values to no avail. I've searched the threads for the answer, but I am missing something. Please advise.

Group 2 Header:
whileprintingrecords;
numbervar G4Total;
if not inrepeatedgroupheader then
G4Total := 0;

Group 4 Footer:
numbervar G4Total;
numbervar G4Total := {@f_PresRd_kWhT}+{@f_G3Footer}

Group 2 Footer:
whileprintingrecords;
numbervar G4Total;
G4Total

I keep getting the value in the Group 4 Footer in the Group 2 Footer. I want to sum each value that is in the Group 4 footer in the Group 2 Footer.
Please advise what i am missing.

Thanks,
Mark

 

[jcrawford08]

It seems to me you could try to actually create a formula that gives you the total you need - {@f_PresRd_kWhT}+{@f_G3Footer} - and then use the running total expert to sum it up, resetting on group 2 and evaluating on change in group 4...

-jcrawford-

Not in word only, but in deed also... 1Jn3:18

 

[mmck1964]

Except the formula field {@f_PresRd_kWhT}+{@f_G3Footer} is not an option to select in the Running Total Fields list. I even created a separate field that looks at the formula field {@f_PresRd_kWhT}+{@f_G3Footer} and it is not in the Running Total Fields list either.

 

[IanWaterman]

Change grp 4 Footer formual to this

Group 4 Footer:
numbervar G4Total;
numbervar G4Total := G4Total+ {@f_PresRd_kWhT}+{@f_G3Footer};

Otherwise you will only get the last value of Group4

Ian