Compare Last Month of Previous Year/Current Month

Technical name: 0QT_PAPD_004

Component of the InfoCube: 0PAPD_C01

Use

This structure displays a comparison between the last posted month of the previous year and the current month (that is, the last month where postings were made in the current calendar year). It also displays the difference expressed as a percentage and as an absolute value.

Element

Selection/Formula

Last month where postings were made (previous year)

(&0T_CMNTH&.&0T_MYEAR&)

Last month where postings were made (previous year)

(0LYMONTH)

Last month where postings were made (current calendar year)

(&0T_CMNTH&.&0T_MYEAR&)

Last month where postings were made (current year)

(0CYMONTH)

Difference

Difference = last month where postings were made (current year) - last month where postings were made (previous year)

Difference in %

Difference in % = last month where postings were made (current year) - last month where postings were made (previous year) / last month where postings were made (previous year) * 100

In 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.

In the structure Compare Last Month of Previous Year/Current Month, the text variables (&0T_CMNTH&.&0T_MYEAR&) are used for Last month where postings were made (previous year) and Last month where postings were made (current year) – in other words, if the current month is February 2000, Last month where postings were made (previous year) will be replaced with 12.1999, and Last month where postings were made (current year) will be replaced by 2.2000.