Quarterly Comparison Including Current Quarter

Technical name: 0QT_5QUARTER

Part of InfoCube: 0PY_C02

Use

This structure shows the comparison between the current quarter and the last four quarters.

Element

Formula

Current quarter

(&0T_CQUAT&)

Current quarter

(&0CQUART&)

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)

If the structures refer to periods, the periods are represented in the structure and the preview as text variables (&0T_CYEAR&, &0T_CQUAT&) and the corresponding values (calendar year, calendar quarter) are automatically generated when the queries are executed.

In the structure "Comparison of Previous Year/Current Year", the "previous year" and "current year" are represented by text variable &T_CALYEA&. When the query is executed, the text variable is replaced by the corresponding calendar years. For example, "previous year" is replaced by 1998 and "current year" is replaced by 1999.