To insert running totals and moving averages in a given field, use the Insert > Running Total and
Insert > Moving Average commands for that field.
The displayed dialog box enables you to specify the source data field these values are calculated for and the following options:
Running Totals
- The initial value the total is set to
- The total type: sum, difference or product
- The range of the fields to be processed: current selection, all currently filtered records, all records in the table
Moving Averages
- Weights - check this option to apply weights to data series values. The default "N...1" selection means that
the latest value in the N-element period will have the weight equal to N and the oldest one: 1.
You can specify your own weights as a column in some other table. The number of weights should be equal to the size of the period, and the first row corresponds to the latest period value. If the number of weights is smaller, the remaining (missing) weights are assumed to be 1. If it's greater, the last weights are ignored. - Period - the number of values each average is calculated for.
- Shift - For the default 0 value, each period for each average ends in the row/record the average is inserted
in, and starts N rows/records above it. As there isn't enough data for the initial N-1 averages,
the corresponding fields will be filled with the #NULL! error values.
Positive 'shift' values move this range down/forward, and negative shift values move it further up. - The range of the fields to be processed: current selection, all currently filtered records, all records in the table
