Skip to Content
avatar image
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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    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

    Add comment
    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