This function calculates the average value of an account over a specified number of prior periods. If the source is a balance type account, the average is based on the entered data. If the source is a flow type account, the average is based on the periodic data only.
The Average value is derived differently based on the Periods parameter.
If the Periods parameter is YTD, the average value is the sum of all periods in the current year up to the current divided by the current period number.
If the Periods parameter is Periodic, the average value is the sum of the current and immediately prior periods divided by two. If the current period is the first period of the year, the average value is the same value as the source.
If the Periods parameter is a number, the average value is the sum of the current and each preceding period for the specified number of periods, divided by the specified number.