# GS-Base 19.9 has been released.

**URL:** <https://community.citadel5.com/t/gs-base-19-9-has-been-released/213>\
**Category:** GS-Base Updates\
**Created:** [December 11, 2023, 12:17pm UTC](https://community.citadel5.com/t/gs-base-19-9-has-been-released/213 "2023-12-11T12:17:50Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![citadel\_5](https://community.citadel5.com/letter_avatar_proxy/v4/letter/c/b2d939/32.png) [@citadel\_5](https://community.citadel5.com/u/citadel_5)\
**Post date:** [December 11, 2023, 12:17pm UTC](https://community.citadel5.com/t/gs-base-19-9-has-been-released/213/1 "2023-12-11T12:17:50Z")

</div>

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.

- 

![](https://citadel5.com/help/gsbase/r_total.png)

- 

**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

- 

![](https://citadel5.com/help/gsbase/mov_average.png)