Syntax

Cumulative (PointOfView, View, NumPeriod)

Table 5. Syntax of Cumulative Function

Parameter	Valid Values
PointOfView	Valid combination of the RHS dimension which includes Account, Custom1….4, ICP members. For example, "A#CASH.C1#[None].I#[ICP Top]"
View	It must be one of the 3 possible values: " " (double quote) - Based on the default view defined for the scenario being processed (either YTD or Periodic). "YTD" - User specifies the Year-to-date option, which overrides the default view set for the scenario. "Periodic" - User specifies the periodic option, which overrides the default view set for the scenario.
NumPeriod	A whole number representing the number of periods in the current scenario to accumulate, starting with the current period. If NumPeriod is 0 or negative, the function will aggregate from the beginning of the current year.

Parameter

Valid Values

PointOfView

Valid combination of the RHS dimension which includes Account, Custom1….4, ICP members. For example, "A#CASH.C1#[None].I#[ICP Top]"

View

It must be one of the 3 possible values:

" " (double quote) - Based on the default view defined for the scenario being processed (either YTD or Periodic).

"YTD" - User specifies the Year-to-date option, which overrides the default view set for the scenario.

"Periodic" - User specifies the periodic option, which overrides the default view set for the scenario.

NumPeriod

A whole number representing the number of periods in the current scenario to accumulate, starting with the current period.

If NumPeriod is 0 or negative, the function will aggregate from the beginning of the current year.