Generate a Running Total of Extended Price

About this task

To generate a running total of the extended price:

Double-click the field that contains the unit price for each line item.
The Field Properties dialog box opens. You already established one accumulator that appears in the list on the Standard Rule tab.
Click New.
The Edit Accumulator Entry dialog box opens to create a new calculation for this field.
From the Primary Accumulator list, select 3.
In the Name box, type Running Total.
From the First list, select Add primary to alternate.
Add primary to alternate specifies that the contents of the primary accumulator are added to the contents of the alternate accumulator, and the result is stored in the primary accumulator for each iteration of the current group.
From the Alternate Accum list, select 2.
The value of accumulator 2 (which contains the extended price for a line item) is added to the value of accumulator 3. The sum is stored in accumulator 3, which therefore contains a running total of the extended price with each iteration of the current group.
In the Edit Accumulator dialog box, click OK to add the accumulator.
In the Field Properties dialog box, click OK to add the standard rule to the Unit Price field.