I am not a model-builder myself but liaise with a team of model-builders. I ask my question as the business owner of Forecasting data.
We have closed previous Forecast version in ANAPLAN (e.g. March FCST) but when a formula is changed ( e.g. for a live April version), all past CLOSED versions automatically update and the $ in the closed versions change.
This is not acceptable as the older versions were published and now if we refer to them live in ANAPLAN for variance analysis, the $ are different to that published in the past for management reporting. Data has to be manually tweaked in excel for prior versions.
How do we avoid this?
... View more