Calculate avg of planned price@aggregated level

[pk1006]

Hello,

I am trying to calculate average of planned price stored at wkprodcust level to month/product family/cust group level. created a new KF with BPL -month/product family/cust group and input KF planned price ....got expected output. But when i used same KF in calculation (revenue/avg price)...system is using individual product's price in family and then dividing revenue(family/cust grp) and final output is coming out at month/product/cust grp level. Any suggestion?

Thanks

PK

[former_member856826]

@pk1006

Based on your description, it seems like you want to calculate the average planned price at the month/product family/cust group level, and then use that average price in a revenue calculation. However, it appears that the system is using individual product prices within the family, resulting in the revenue being calculated at the month/product/cust grp level instead.

To ensure that the average planned price is correctly calculated and used in the revenue calculation, you can follow these steps:

1. Make sure you have the planned price stored at the wkprodcust level.
2. Create a new calculated key figure (KF) to calculate the average planned price. Use a formula that aggregates the planned prices at the month/product family/cust group level. For example, you can use a formula like SUM(Planned Price) / COUNT(Distinct Product) to calculate the average price.
3. Verify that the new KF for average planned price is giving you the expected output at the month/product family/cust group level.
4. For the revenue calculation, instead of directly dividing revenue by the average price, use a new calculated KF that multiplies revenue by the average planned price. This calculated KF will ensure that the revenue is calculated at the month/product family/cust group level.

By creating separate calculated key figures for the average planned price and the revenue calculation, you can ensure that the calculations are performed correctly at the desired level of aggregation.