The account CASH will return the following values for Jan, Feb, and Mar, 2001 depending on the Number parameter used in the Cumulative function.
The account SALES will return the following values for Jan, Feb, and Mar, 2001 depending on both the View and Number parameters used in the Cumulative function. The default view set for the scenario being processed is YTD.
Table 6. Example of Cumulative Function
Account | Oct2000 | Nov2000 | Dec2000 | Jan2001 | Feb2001 | Mar2001 |
|---|
A#Cash | 1,000 | 1,500 | 1,200 | 800 | 1,100 | 1,300 |
Cumulative(“A#Cash”, “”, 0) | N/A | N/A | N/A | 800 | 1,900 | 3,200 |
Cumulative(“A#Cash”, “”,3) | N/A | N/A | N/A | 3,500 | 3,100 | 3,200 |
A#Sales | 9,000 | 10,500 | 11,700 | 800 | 1,900 | 3,200 |
Cumulative(“A#Sales”, “”,0) | N/A | N/A | N/A | 800 | 2,700 | 5,900 |
Cumulative(“A#Sales”, “Periodic”,0) | N/A | N/A | N/A | 800 | 1,900 | 3,200 |
Cumulative(“A#Sales”, “Periodic”,3) | N/A | N/A | N/A | 3,500 | 3,100 | 3,200 |