The CASH account will return the following values for January, February, and March 2014 depending on the Number parameter used in the Cumulative function.
The a SALES account will return the following values for January, February, and March 2014 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 93. Example of Cumulative Function
Account | Oct2013 | Nov2013 | Dec2013 | Jan2014 | Feb2014 | Mar2014 |
|---|---|---|---|---|---|---|
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 |