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

[Former Member]

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_member242371 · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Rohit..It works