Comparison Last Month of Previous Year/Current Month 
Comparison Last Month of Previous Year/Current Month
Technical name: 0QT_PA_022
Component of the InfoCube:
0PA_C01Use
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.