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

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



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