Example

The SALES account will return these values for January, February, and March 2014 depending on the Periods parameter used in the Average custom function. The default view set for the scenario being processed is YTD.

Table 91. Example of Average Function

Account

Oct2013

Nov2013

Dec2013

Jan2014

Feb2014

Mar2014

A#Sales

9,000

10,500

11,700

800

1,900

3,200

Average(“A#Sales”, “YTD”)

N/A

N/A

N/A

800

950

1,067

Average(“A#Sales”, “Periodic”)

N/A

N/A

N/A

800

950

1,200

Average(“A#Sales, “3”)

N/A

N/A

N/A

1,167

1,033

1,067