Running totals are totals that are displayed generally on a record-by-record basis. They total all records (in the report, in the group, and so on) up to and including the current record. The most basic form of a running total is a single running total maintained throughout a list.
You create running total fields with the Running Total Expert, which allows you to select the field to summarize, the summary operation to use, a condition upon which to base the evaluation, and a condition upon which to reset the evaluation.
Note A running total field can be used on database fields and first-pass formulas, but cannot be used on second-pass formulas or formulas that reference other second-pass formulas. See Report Processing Model.
To create a running total in a list
For a running total in a list, click "On change of field."
This gives you a running total that never resets; that is, the running total continues throughout the report and provides a grand total.
Your running total now appears in the Field Explorer, under Running Total Fields.
Note A running total that is placed on a report is indicated by the # prefix (for instance, #Total1).