Comparison Last Month of Previous Year/Current Month

Technical name: 0QT_PA_022

Component of the InfoCube: 0PA_C01

Use

This structure displays the values for the month most recently posted in both the previous year, and the current calendar year. It also displays the difference expressed as a percentage and as an absolute value.

Element

Selection/Formula

Month most recently posted (previous year)

(&0T_CMNTH&.&0T_MYEAR&)

Month most recently posted (previous year)

(0LYMONTH)

Month most recently posted (current calendar year)

(&0T_CMNTH&.&0T_MYEAR&)

Month most recently posted (current calendar year)

(0CYMONTH)

Difference

Difference = month most recently posted (current calendar year) - month most recently posted (previous year)

Difference in %

Difference in % = month most recently posted (current calendar year) - month most recently posted (previous year) / month most recently posted (previous year) * 100

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.

The "Comparison Last Month of Previous Year/Current Month" structure uses text variables (&0T_CMNTH&.&0T_MYEAR&) for "month most recently posted (previous year)" and "month most recently posted (current year)". In February 2000, for example, "month most recently posted (previous year)" is replaced by 12.1999, and "month most recently posted (current year)" is replaced by 2.2000.