Good Morning,
We are currently running into an issue due to the fact that out Actuals are loaded to version "Final", and our forecast is sitting in version "Working" until it is signed off on, at which time it is pushed to version "Final". Below is our current member formula for the variance scenario "Actual vs Forecast";
@VAR("Actual",&CurrFcst);
When retrieving this member in SmartView, we are obviously unable to retrieve the correct result, because we have to select either "Working" or "Final". When we set to Final, it is calculating (actuals - 0), and when we set to Working, it is calculating (0 - forecast). Anyone experience this and able to resolve? It seems as though, I need to enter an IF statement in the formula, but I am rather new to Planning, so not sure if that would work. I am trying to avoid having to create another scenario, along the lines of (not sure that would work either, as I am not sure what version they would select in SmartView);
@VAR( Actual->Final, CurrFcst->Working )
One obvious fix is to push the Forecast over to Final at anytime during close to view the result, but the business is not familiar enough with the system yet to be moving data without purpose.
Thanks for any assistance.