2.3.10 Activity: Create Demand Forecast Formulas

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

Best Answer

  • 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 :)