summarizeperiods
summarizeperiods(expression) summarizeperiods(expression,from,to)
The SUMMARIZEPERIODS function has the following argument:
expressionThe expression to be evaluated.
from(Optional) The starting period to be evaluated.
to(Optional) The ending period to be evaluated.
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.
|
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 |