Forum Discussion
Solved
Copy Actual to Forecast issue
Hi all,
We have a simple copy calculation on a forecast scenario that copies in the actuals data for certain periods, defined in a text field. We've had it for years and it generally works fin...
HI Nicole - where is this calculation written? If it is NOT a Custom Calc, you could move this to FP 16. This would ensure its the last thing to run and if its successful, it likely points to a formula pass issue and/or another formula overwriting those numbers.
A few other unrelated items:
- this does not have any Entity conditions - does it need to run at parent Entities for any reason?
- the current month can easily be grabbed with api.Time.GetPeriodNumFromId(api.Pov.Time.MemberId) rather than parsing the time name
Nicole,
I had a similar issue with a calculation that never had any issues in the past but for some reason started giving me problems. After hours of banging my head against the wall and rerunning the rule over and over, I decided to restart IIS on all servers and retry. After doing this, the calculation worked as expected. Since restarting IIS is a simple process, maybe you can try that if you have done everything else you can think of.
Hi Mark - thanks so much for the suggestion! Reset servers in PROD and DEV and reran the consolidation/calc with no changes. Still having this odd issue but thanks for the suggestion as I wouldn't have thought of that.
