Average of Last 4 Quarters 
Average of Last 4 Quarters
Technical name: 0QT_PA_010
Component of the InfoCube:
0PA_C01Use
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 ".