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

Options

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

Best Answers

  • KirillKuznetsov
    Answer ✓
    Options

    @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
    Answer ✓
    Options

    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
    Options

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

  • DSS
    Options

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