Name

summarizeperiods — Add the values of an exprssion over a set of periods.

Syntax

summarizeperiods(expression)
summarizeperiods(expression, from, to)
              

The SUMMARIZEPERIODS function has the following argument:

expression

The expression to be evaluated.

from

(Optional) The starting period to be evaluated.

to

(Optional) The ending period to be evaluated.

Description

This function will evaluate an expression over a set of planning periods.

in the first form the expression will be evaluated over all planning periods.

In the second form the expression will be evaluated over the specified range of planning periods.

Examples

Formula

Description

Result

summarizeperiods(product.Yield.total)Sum the total harvested yield attribute over all planning periods 
summarizeperiods(product.Yield.total, 1, 3)Sum the total harvested yield attribute over the first three planning periods