I need some assistance understanding the limitation of Version Formulae and how it interacts with Formula Scope.
I have inherited a model build which has a comprehensive P&L module (down to GL level) split into its respective areas - revenue lines, cost lines, etc.
Each respective area naturally points to a different part of the model for forecast - so revenue forecast drivers go to the revenue forecast driver modules and same with cost etc.
Previously the model was set up such that actuals were imported directly into actual version against line items and we want to move to a flat trial balance method instead. However; the model utilises bulk copy method to snapshot historic versions for budget, forecast 1, 2 etc.
Hence, formula scope is set to Current Version with rollup summary lines (i.e Total Revenue) as formula scope of "All Versions".
I would expect it to clash with Version Formula - but the problem is how do we best overcome this limitation?
Implementing a data hub (whilst best practice) probably isn't going to suit retrospective implementation based on the WS size, and client needs at this moment in time, but might be possible at some point in the future.
Advice much appreciated.
TIA