Syntax

Average (PointOfView, Periods)

Table 3. Syntax of Average Function

Parameter	Valid Values
PointOfView	Valid combination of the RHS dimension which includes Account, Custom1….4, ICP members. For example, "A#CASH.C1#[None].I#[ICP Top]" For flow type accounts, the function will average only the periodic value.
Periods	It must be one of the three possible values: "YTD" - User specifies the year-to-date option to average the cumulative data from period one in the current year. "Periodic" - User specifies the periodic option to average the current and immediately prior period in the current year only. For the first period this value will be the same as the source. "[any whole positive number]" - User specifies a number of periods over which the average is to be calculated. For a rolling year average in a monthly category, the user would specify "12" here.

Parameter

Valid Values

PointOfView

Valid combination of the RHS dimension which includes Account, Custom1….4, ICP members. For example, "A#CASH.C1#[None].I#[ICP Top]"

For flow type accounts, the function will average only the periodic value.

Periods

It must be one of the three possible values:

"YTD" - User specifies the year-to-date option to average the cumulative data from period one in the current year.

"Periodic" - User specifies the periodic option to average the current and immediately prior period in the current year only. For the first period this value will be the same as the source.

"[any whole positive number]" - User specifies a number of periods over which the average is to be calculated. For a rolling year average in a monthly category, the user would specify "12" here.