Average of Last 4 Quarters

Technical name: 0QT_PA_010

Component of the InfoCube: 0PA_C01

Use

This structure displays the values from the last four quarters, as well as the average value.

In the structure, the calculation starts with the last complete quarter since there are complete values available. A query executed in the second quarter of the year 2000 to compare four quarters would take the values from the four previous complete quarters: 1/00, 4/99, 3/99 and 2/99.

Element

Selection/Formula

Current quarter -4

(&0T_CQUAT&-4)

Current quarter -4

(&0CQUART&-4)

Current quarter -3

(&0T_CQUAT&-3)

Current quarter -3

(&0CQUART&-3)

Current quarter -2

(&0T_CQUAT&-2)

Current quarter -2

(&0CQUART&-2)

Current quarter -1

(&0T_CQUAT&-1)

Current quarter -1

(&0CQUART&-1)

Average of 4 quarters

S of quarter values / 4

In templates/structures that refer to time periods, the time periods are displayed as text variables (such as &0T_CYEAR&, &0T_CQUAT&) in the structures and the preview. When you execute a query, the actual values (calendar year or quarter) are automatically generated.

In the structure Average 4 Quarters, the text variable &0T_CQUAT& is taken to represent the current quarter. When the query is executed, the text variable is replaced by the actual quarters or previous quarters. In other words, according to the calculation rule explained above, a query executed in the third quarter of 2000 would replace current quarter - 1 with "2nd quarter 2000" and current quarter - 2 with "1st quarter 2000 ".