Average 4 Quarters - Previous Year

Technical name: 0QT_PA_012

Component of the InfoCube: 0PA_C01

Use

This structure displays the values for the four quarters of the previous year, as well as the average value.

Element

Selection/Formula

 

1st Quarter of Previous Year

Quarter (0CALQUART1) restricted to 1 and
&0CYEAR&-1

 

2nd Quarter of Previous Year

Quarter (0CALQUART1) restricted to 2 and
&0CYEAR&-1

 

3rd Quarter of Previous Year

Quarter (0CALQUART1) restricted to 3 and
&0CYEAR&-1

 

4th Quarter of Previous Year

Quarter (0CALQUART1) restricted to 4 and
&0CYEAR&-1

Average 4 Quarters - Previous Year

S of quarter values (previous year) / 4