Former Member

### 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

10|10000 characters needed characters exceeded

• Former Member
Sep 02, 2014 at 08:08 PM

Hi Pierre

Is your macro calculating the Final forecast running interactively or in Background ?

It seems that your macro do the calculation at each level (total and SKU level)

KR

Arno

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi again Pierre

Your settings from the screenshot are good, but having the result 480  (600 * (1-20%) before drill down because the macro calculate at total level using the LCf average value is a normal situation.

You should have after drill down at SKU level the expected result

Personally I prefer to work with a Pushbutton macro (better for performance reason) starting a collective macro doing first a drill down step, then calculation and finally a drill up

KR

Arno