Hi Lingaiah,
We looked into the problem again and found out that actually the computation is not wrong in itself: it only has a time offset of 12 months, see below:
To be sure, we created a new calculated KF "Sales Rep Unconstr Fcst Vol 2" equal to "Sales Rep Unconstr Fcst Vol", and it is also shifted by 12 months.
The problem seems to be around the time profile. Do you have any idea what could be wrong there?
Best regards,
Ivan
Dear all,
The issue is now resolved. The problem wasn't due to faulty computation in calculated KFs, but because of an Attribute transformation (aiming at shifting KF values by 12 months) which was done on the wrong planning level.
Thanks again for the answers.
Best regards,
Ivan
Hi Ivan,
Can you share Sales Rep Unconstnt Fcst Vol - calculation graph logic.
Best Regards,
Lingaiah
Hi Jorge and Lingaiah,
Thanks for your quick replies. You can find the graphs below:
For the last one (ALLOCATIONVOLUME), it takes SUPPLYAVAILABILITY if and only if ALLOCATIONVOLUME is null, which is not the case with the loaded data; so ALLOCATIONVOLUME can be considered like a purely stored KF.
H Ivan,
Can you try to delete the forecasted price value and maintain once again.
Also Sales Rep Uncons Fcst Value key figure changed to Editable and make the change and test it.
Best Regards,
Lingaiah
Add comment