I am completely new to OBIEE and have never used it before and I am having trouble creating a rolling average formula that will calculate the forecast for the next 6 and next 12 months. For example,
I have tried the MAVG function, but that only calculates the Previous avg of the available months.
I have created a repository variable in the RPD with CURRENT_MONTH, but when I try to add the VALUEOF(CURRENT_MONTH)+6 - it gives an error.
Any input is totally appreciated!
why dont you go for Period Rolling option that is a new feature in 11g.
The expression for the 3-month rolling average is:
PeriodRolling("Sales"."Base Measures"."Dollars" , -2, 0) /3