How to calculate forecast percent based on latest 3 months (average) actuals?
I have a source module without a version list/dimension. It contains only actuals.
What I would like to do is a new module that contains actuals and forecasts. There should be a version list, which contains Actuals and Forecasts. Forecast figures should be calculated from the latest 3 months average (from actual version).
My question is what kind of setup is best and what kind line item formula I should implement to target module?
The attached is picture illustrates my need better.
I think that there is a mistake Forecast LI: MOVINGSUM(Actuals LI,-2,0,SUM) -> SUM should be AVERAGE. Another issue is that line item brings only the correct value for first forecast period (Mar 20). March 20 value should be for all forecast periods.
The third thing that SELECT: Versions.Actual doesn't work either because the source module doesn't include version.
Thank you it works! What's your opinion from performance point of view if I would like to put actual + forecast as one line item. This line item could use switchover or would it be better from performance point of view to use Version module?