Search
Search

# DP Local Key Figure Discrepancy between Aggregated level and lowest level

Dear,

Here is my issue.

Forecast (key figure)

Life Cycle Factor (key figure)

Final Forecast (Local Key figure)

Final forecast = Forecast * (1- LCF (%) )

Example :

Product 1 = 100

Product 2 = 200

Product 3 = 300

TOTAL FORECAST = 600

If I assign a life cyle factor to Product 1 = 60

Total LCF appears  = 20 (60 + 0 + 0) => OK

Final Forecast Product 1 = 40        => OK

Final Forecast Product 2 = 200      => OK

Final Forecast Product 3 = 300      => OK

Total Final Forecast =  480  (600 * (1-20%)        => NOK

I have a very strange situation because  at the product level, the formula is OK   => Final Forecast = Forecast * (1 - LCF(%) )

BUT Total Final Forecast should be the sum of the each product Final forecast = 40 + 200 +300 = 540.

Can you help me to understand what I have to correct for  this aggregation ?

Thanks a lot for your help

PE

##### Former MemberSeptember 03, 2014 at 11:30 AM0 Likes
View more on this topic or