MOVINGSUM

Returns the moving sum over the last WindowSize elements including the current one. If there are not enough elements with values null is returned.

MOVINGSUM(Node, TimeLevel, WindowSize)

• Node: Input node, specified using the node name in single quotes (e.g. 'Profit')

• TimeLevel: Name of the time level that forms the time series to sum up (e.g. "Month")

• WindowSize: Number of elements (including the current one) to sum up (e.g. 3)

2019-Q1

30

2019-Q2

120

2019-Q3

210

2019-Q4

300

2019-Q2

150 → (30+120)

2019-Q3

330 → (120+210)

2019-Q4

510 → (210+300)