Average 4 Quarters - Previous Year (End of Quarter)

Technical name: 0QT_PA_023

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, with reference to the end of the quarter.

Element

Selection/Formula

 

1st Quarter of Previous Year

Calendar month (0CALMONTH2) restricted to 3 and
&0CYEAR&-1

 

2nd Quarter of Previous Year

Calendar month (0CALMONTH2) restricted to 6 and
&0CYEAR&-1

 

3rd Quarter of Previous Year

Calendar month (0CALMONTH2) restricted to 9 and
&0CYEAR&-1

 

4th Quarter of Previous Year

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

Average 4 Quarters - Previous Year

S of quarter values (previous year) / 4