Compare Year with Previous Year

Technical Name: 0QT_YEAR A_F

Component of the InfoCube: 0PT_C01

Use

This structure displays the percentage distribution between the difference of selected time and labor from the current year (minus time and labor from the previous year), in relation to the selected time and labor of the previous year. In other words, selected time and labor of one year can be compared with times of the previous year.

Element

Selection/Formula

Difference in %

Difference in % = (current year - previous year)/previous year in %

Current year

Previous year

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.