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.