Dear all,
I'm experiencing the following issue: 2 calculated KFs are defined exactly the same way. The first one works correctly (green box below) but the second one displays totally wrong results in excel (red box).
- Both are revenues defined as the product: FORECASTEDPRICE (stored KF) x corresponding VOLUME (stored KF), see below.
Where FORECASTEDPRICE is defined as follows:
Does anyone have an idea about a possible resolution ?
Thanks,
Ivan
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
did you saw on the definition graph?
maybe you can see if you have problem in the definition.
Best Regards
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