on 10-18-2022 4:50 PM
Hi experts,
we're trying to create a KF calculation that will calculate the projected price based on an initial price and monthly raises in % as shown in the picture.
Projected price (month n) = projected price (month n-1) * (1 + Price change(n))
Does anybody know how to do this in kf calculations? we tried using IBP_LPA and IBP_PERIODSHIFT but anything seems to work.
Any advice is greatly appreciated. Thanks!
Hi Lucas,
Assuming the price change is constant throughout the periods, you can use below key figures as a calculation of the projected price:
KF1: Copy the price to each bucket in future buckets.
KF2: The "Price change %" key figure in your example. (preferred this as an Attribute as KF)
KF3: Count key figure, Current bucket = 0; next month = 1; next to next month = 2 and so on.
KF4 (Projected Price) = KF1 *(1+ KF2 %)^KF3. Note: for power operator use ** instead of ^.
Please find attached the KF calculation details for reference.
Hope it helps.
Regards,
Praveen Jadhav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Praveen,
thanks for your answer. This issue appeared when working for a company in Argentina where prices usually change a lot, so unfortunately the price change is not the same throughout the periods and therefore we cannot use your solution. We ended up calculating the projected price with a local member (the calculation is super simple in Excel) and then copying those values to the key figure using a macro with VBA code.
Hopefully SAP will come with a better solution in the future.
Regards,
Hello szuffiaurre
Whether you use IBP_LPA and IBP_PERIODSHIFT or CAGGR along with, you cannot acheive the desired caluclation using standard KF expressions available. The reason behind is your calculation formula is having n dynamically calculated in 2 different inputs in the calculation. This cannot be done using KF expression as it will form a loop cycle in the calculation.I think this calculation will be a good candidate for Lcode. My suggestion would be to raise an OSS for Locde to SAP and see what they can come up with.You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
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.