Syntax

Cumulative (PointOfView, View, NumPeriod)

Table 92. Syntax of Cumulative Function

Parameter

Valid Values

PointOfView

Valid combination of Account, Custom1….4, ICP members, for example, "A#CASH.C1#[None].I#[ICP Top]"

View

Must be one of these 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 - Specify 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 aggregates from the beginning of the current year.