Comparison of Previous/Current Year

Technical name: 0QT_2YEAR_2

Part of InfoCube: 0PY_C03

Use

This structure shows the comparison of the current year to the previous year.

Element

Selection/Formula

Current calendar year

Current calendar year

Previous year

Current calendar year - 1

Difference

Current year – previous year

Difference (%)

Percentage difference

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.