New features in GS-Base 19.9:

- Inserting running totals and moving averages.

To insert running totals and moving averages in a given field, use the Insert > Running Total and

Insert > Moving Average commands for that field.

You can calculate these values in a column for up to 256 million rows in seconds.

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 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 tables.

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 are no enough data for

the initial N-1 averages, the corresponding fields will be filled

with the #NULL! error values.

Positive ‘shift’ values moves this compartment down/forward and

negatives shift values - further up. - The range of the fields to processed: current selection, all

currently filtered records, all records in the table