Example

The CASH account will return the following values for January, February, and March 2014 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 95. Example of Difference Function

Account

Dec2013

Jan2014

Feb2014

Mar2014

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