Create DEM03 Demand Forecast Module: Growth Rate % line item zero values

DSS
DSS
in Modeling

Hi

Anyone who can help me with the formula for "Growth Rate %" line item?

I put this formula ('DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]) but I have zero values

image.png
image.png

Best Answers

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓

    @DSS check that your source module DEM02 Volume Growth Rates by Week. Has values on Product Family level and it is not zeros (for example, due to summary method set to None)

    Otherwise please show me source module DEM02 Volume Growth Rates by Week

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓

    As you can see you use Months in the source, while in the target you have Weeks. I don't think you need a month level in this module. Try to change it to weeks. (but first, you would need to remove MONTHVALUE() function).

Answers

  • DSS
    DSS

    Thanks, but as you can see the source module should be correct.

    image.png
    image.png

  • DSS
    DSS

    Thank you, I changed the time scale in the source module and now it works!

Categories