Average 12 Months - Previous Year

Technical name: 0QT_PA_014

Component of the InfoCube: 0PA_C01

Use

This structure displays the values for the 12 months of the previous year, as well as the average value.

Element

Selection/Formula

 

January of Previous Year

Month (0CALMONTH2) restricted to 1 and
&0CYEAR&-1

 

February of Previous Year

Month (0CALMONTH2) restricted to 2 and
&0CYEAR&-1

 

 

December of Previous Year

Month (0CALMONTH2) restricted to 12 and
&0CYEAR&-1

Average 12 Months - Previous Year

S of monthly values (previous year) / 12