The account CASH will return the following values for Jan, Feb, and Mar, 2001 depending on the View parameter used in the Difference function. The default view set for the scenario being processed is YTD. The Difference function subtracts the opening value from the current period value.
Table 8. Example of Difference Function
Account | Dec2000 | Jan2001 | Feb2001 | Mar2001 |
|---|
A#Cash | 900 | 1,200 | 1,100 | 1,500 |
Difference(“A#Cash”, “”) | N/A | 300 | 200 | 600 |
Difference(“A#Cash”, “YTD”) | N/A | 300 | 200 | 600 |
Difference(“A#Cash”, “Periodic”) | N/A | 300 | -100 | 400 |