Comparison of Previous/Current Year

Technical name: 0QT_2YEARS_DIFF

Part of InfoCube: 0PY_C02

Use

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

Element

Formula

Previous year

(&0T_CYEAR&)

Previous year = current calendar year-1

(&0CYEAR&-1)

Current calendar year

(&0T_CYEAR&)

Current calendar year = variable current calendar year

(&0CYEAR&)

Difference

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.