Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Correct Calculation for Price Keyfigures in Week,Month,Quarter and Year Level

Hi Experts,

I am using Unified Planning Area. I have a very simple requirement for Actuals Price Calculation. It should be Actuals Revenue / Actuals Qty.

Now the issue that I am facing is: While I am at week level and say for Week 1: Actuals Rev is 2000 and Actuals Qty is 200 then Actuals Price is showing 10, but as soon as I am at month level the Price at week level is just getting summed up. Can anyone please suggest how i should configure my Keyfigure such that when I am at week or month or quarter level the price value should be exactly Actuals Revenue/Actuals Quantity at that level. Please let me know if i have made my requirement clear.

Former Member
replied

Hi Sanjit,

You need to define customĀ  calculation at request level for Actuals Price so that value does not get aggregated. For example-

AcualsPrice@request = ActualsRevenue@request / ActualsQty@request

Thanks,

Rohit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question