Comparison Last Month of Previous Year/Current Month

Technical name: 0QT_PARC_011

Component of the InfoCube: 0PARC_C01

Use

This structure displays a comparison between the month most recently posted in the previous year, and the current month (that is, the month most recently posted in 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 year)

(0CYMONTH)

Difference

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

Difference in %

Difference in % = month most recently posted (current 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.