Syntax:

RollingPeriods, Column, 0, stepBy, count, aggregation

Parameters:

param1 – unused { 0 }

stepBy – direction of the aggregation { 1 for forward, -1 for backward }

count – number of values to be used in each aggregation

aggregation – the aggregation to be used { Average, Sum, Maximum, Minimum, Median }

Examples:

RollingPeriods,Column,0,1,2,Sum

Calculates the Sum of each column plus the column immediately to the right.

RollingPeriods,Column,0,-1,3,Average

Calculates the average over 3 periods (to the left) starting at column 0 and stepping 1 column at a time.

Comments:

When performing backwards averaging, the first columns are not complete count-period averages, so you may want to remove them so the report is not misleading.

Blank cells are evaluated as zero for Sums and Averages.