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
