Syntax

Average (PointOfView, Periods)

Table 90. Syntax of Average Function

Parameter	Valid Values
PointOfView	Valid combination of Account, Custom1….4, ICP members, for example, "A#CASH.C1#[None].I#[ICP Top]" For flow type accounts, the function averages only the periodic value.
Periods	Must be one of these values: YTD - Specify the year-to-date option to average the cumulative data from period one in the current year. Periodic - Specify 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] - Specify a number of periods over which the average is to be calculated. For a rolling year average in a monthly category, specify "12".

Parameter

Valid Values

PointOfView

Valid combination of Account, Custom1….4, ICP members, for example, "A#CASH.C1#[None].I#[ICP Top]"

For flow type accounts, the function averages only the periodic value.

Periods

Must be one of these values:

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

Periodic - Specify 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] - Specify a number of periods over which the average is to be calculated. For a rolling year average in a monthly category, specify "12".