Comparison of Previous/Current Year

Technical name: 0QT_2YEARS_DIFF

Part of InfoCube: 0PY_C02


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



Previous year


Previous year = current calendar year-1


Current calendar year


Current calendar year = variable current calendar year



Difference = current calendar year-previous year

Difference in %

Difference in % = (current year-previous year) / previous year in %

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.