on 12-22-2016 2:50 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan,
Can you share Sales Rep Unconstnt Fcst Vol - calculation graph logic.
Best Regards,
Lingaiah
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ivan
did you saw on the definition graph?
maybe you can see if you have problem in the definition.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.