Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Total wrong on Record Footer 1

Status
Not open for further replies.

kpeak

IS-IT--Management
Mar 10, 2004
12
US
I am using the following formula to compute a running total at the Group Footer level.
WhilePrintingRecords;
numberVar fit_runtotal :=fit_runtotal + {@gross_adj}

The number calculates fine and the last GF1 line has the correct total. However I would like to have the last GF1 line total display in my Report Footer and everything I try seems add the last record amount back into the total.
(i.e. fit_runtotal on the last line may show 10,200 and @gross_adj on the last line is 150.60. Instead of 10,200 in my report footer I get 10,350.60 because it adds the 150.60 again.)

 
Create a separate formula {@display} in the report footer:

whileprintingrecords;
numberVar fit_runtotal;

This will display the last value without adding the last value again.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top