issue with DEM-03 for sprint 2


The following is the screenshot of the the formulas for the line items. but the values i am getting are close to the correct values. did the process for the DAT01,DEM02 from the action tab. the values i am getting are really close to the correct values. please check the formulas and provide the feedback to obtained the accurate values.

Thank you

with regards


Best Answer

  • Venki9902
    edited June 2023 Answer ✓

    Hi @mohammed007 ,

    Can you share the baseline forecast formulas if possible?

    formula for baseline forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Default Forecast, -52, 0)



  • Hello @Venki9902

    Thanks I really appreciate your effort and time.

    I got the issue fixed, same structure of the formula but the variables were wrong.

    have a great day,