Manual Running Total.
Create an initializing formulato go in the Group Header that is:
whileprintingrecords;
global numbervar nTotal:= 0;
Then create a calculation formula to go in the detail section (or whatever section the field to evaluate is in) that is:
whileprintingrecords;
global numbervar nTotal:= nTotal + (if {field}='X' then {field} else 0);
nTotal;
In the group footer, put the same calculation formula. Since there is no field to evaluate in the footer, it will give you the last amount evaluated. I've also gotten into the routine of creating a third formula, though, to just display the amount in case something funky is going on. The display formula would be:
whileprintingrecords;
global numbervar nTotal;
nTotal;
I know this seems like an around the universe way of doing it, but sometimes Running Totals don't work properly depending on the fields you use and how you want the information evaluated.
Edited by FrnhtGLI - 26 Aug 2009 at 9:23am
IP Logged
