Creating running totals using a formula

If you have suppressed data, or your data is based on a formula that occurs WhilePrintingRecords, you should create a running total formula rather than using the Running Total Select Expert.

When you create a running total manually, you need to create three formulas:

• a summary formula
• a reset formula to set a variable to zero
• a display formula to display the variable.

In the following procedure, you will create a report that performs the following functions:

• maintains a running total of customer orders
• groups customer orders and resets the running total for each group
• displays the subtotal for each order (the last running total for that order).