L2 - Spring 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module

Baskar
Baskar
in Modeling
  • Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks

For this task, I have applied the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but this formula seems to be incorrect. The values in the weekly columns are 0 instead of monthly value/no of weeks in the month. What am I doing wrong?

Answers

  • seymatas1
    seymatas1

    Hi @Baskar,

    Did you try MONTHVALUE() instead?

  • Baskar
    Baskar

    Hi @seymatas1 ,

    Thanks.

    my understanding is

     DEM01 Volume Growth Rates.Growth % line item has a monthly value ( Dimension time (month) and in DEM02 Volume Growth Rates by Week module time is in weeks. I thought the value in DEM01 volume Growth Rates.Growth% should be divided by the number of weeks in that month and copied into DEM02 Volume Growth Rates by Week.growth% line item.

    If I apply mothlyvalue(), the values in DEM01 are copied to the DEM02 module Growth% line item. I am confused.

    correct me if my understanding is wrong

    Thanks,

    Baskar

  • seymatas1
    seymatas1

    Hi @Baskar,

    If I apply mothlyvalue(), the values in DEM01 are copied to the DEM02 module Growth% line item.

    Yes, and this is the expected output.

    The values in the monthly module are growth rates from a week to the same week of the next year. So you don't need to change numbers. By using MONTHVALUE(), you carry them from the monthly module to the weekly module without causing time dimension errors.


    For example,

    Your Baseline Forecast for Nutzo Bar_EN, Candiate is 58.88,

    Growth rate is %1.

    Default Forecast = 58.88 x 0.01 = 59.47.

    image.png

    I hope this clarifies things.

    Seyma Tas 🌷🙂

Categories