Example

The account SALES will return the following values for Jan, Feb, and Mar, 2001 depending on the Periods parameter used in the Average custom function. The default view set for the scenario being processed is YTD.

Table 4. Example of Average Function

Account

Oct2000

Nov2000

Dec2000

Jan2001

Feb2001

Mar2001

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