Skip to Content
0
Former Member
Jan 29, 2008 at 07:08 PM

Running Total on a Running Total

23 Views

Post Author: MikeA-ICE

CA Forum: General

I have set up a running total on a field in a subreport and it is calculating correctly. I set the running total in the Report Footer of the report, then I created a variable which passes the running value back to the main report. The variable is placed in a Group Footer on the main report and it resets on each change of the group. However, now I need the grand total of that running total to appear in the Report Footer of the main report. I created a manual running total formula and placed it it in the Report Footer of the main report. Here it is:NumberVar Sect2MatlTotal;WhilePrintingRecords;NumberVar Sect2MatlTotal := NumberVar RunningSect2MatlTotal + {@Material$Var2a} The problem is that the value that comes out is grossly larger than it should be. It should be $112,350,582 but it comes back as $212,603,556, which is nearly double what it should be. Can anyone suggest a method that would allow me to place the running total in the Report Footer of the main report and get the correct value that is visible in the Group Footer just above it?