AVERYTD1
This function computes an average that is based on YTD values for two or more periods for an account and actuality.
The number of periods is used for dividing, regardless of the existence of any values in each period. This formula is suitable for balance sheet accounts.
Syntax: AVERYTD1 (account, actuality, period, number of periods/start period)
Specify a start period in the relative format (for example 'N112' or 'P001') to create a dynamic interval. Or specify the number of periods to always use the same number of periods in the calculation.
IBM® Cognos® Controller uses the start period in combination with the period argument so that the number of periods to include in the average calculation each time you run the function. If you set period to '+0' and start period to 'P001', then the average calculation starts from the first period of the financial year (P001) and ends with the current period (+0). The current period is the period that you select at run time.
Example 1:
AVERYTD1(#B1199#, CURRENT, +0, N112)
Suppose you run AVERYTD1(#B1199#, CURRENT, +0, N112) for the monthly actuality 'AC' and period 1209. This advanced formula calculates the average of YTD values on account B1199 from December 2011 to September 2012. The base of the calculation includes both the starting and the ending period.
Example 2:
AVERYTD1(#account1#, AC, +0, 4): Average for account account1, actuality AC for the last four periods including the current period. If the current period=0901, YTD values are retrieved from 0810+0811 + 0812 + 0901 and divided by 4.
Missing data is interpreted as zeros. The next table shows the result for AVERYTD1(#account#, AC, +0, 4):
| Dim combination | PER-3 | PER-2 | PER-1 | PER | AVERYTD1 |
|---|---|---|---|---|---|
| EU CAR | 1 | 3 | 4 | 2 (8/4) | |
| EU BIKE | 1 | 2 | 1 | 1 (4/4) | |
| US CAR | 1 | 6 | 1 | 4 | 3 (12/4) |
| US BIKE |