Switchover, use it or build your own?
Hi All -
In the context of an FP&A use case, we're trying to evaluate whether to use switchover or just build a system module to dictate where the forecast begins and the actuals end. Would love to hear about pros and cons of both approaches. Here's what I have so far:
Pros of using native switchover:
1) Ability to use formula scope, thereby allowing for a formula to work for actuals and then allow for direct data input for forecasted months.
Cons of using native switchover:
1) Potential for reducing size of model by removing "Actual" version altogether.
Any more insight/preferences/best practices would be appreciated here.