2.3.10 Activity: Create Demand Forecast Formulas

Carlos3k
Carlos3k
in Academy Discussions

My formulas are showing incorrect data. I don't know where I'm wrong. Can someone help

image.png

Best Answer

  • Venki9902
    Venki9902
    Answer ✓

    Hi @Carlos3k ,

    The formula for baseline forecast is seems to be wrong.
    The formula you have used will work only on 1st forecast year of the weeks,remaining weeks that does not comes under the forecast year then you have to use the offset function to get the data from previous 52 weeks.

    Hope this helps :)


    Regards,
    Venkatesh

Answers

Categories