Printable View
I have a running total that runs thru and adds things up for me, it works great
but i need the TOTAL of that running total in my group footer, any ideas??
at the moment it just prints it as a normal running total, slowly building up like it should, but how would i use that final value in a formula used in a groupfooter, because at the moment it returns whatever the Running total is up 2 at that point of evaluation.
bah i have just heard that it is not possible. FECK
Use summaries on the field instead of a running total. This way you can have a formula at the group footer level that uses both the summary at that group point, and the overall summary total. This is how I do percentages that are broken out by groups.
i wish i could use a summary, but i use every feature of the running total like evaluate when this field changes, and reset on a certain condition. and i cant see how i could emulate that in a formula....
anyway i think i might be able to use SQL query expressions to get around this perhaps.