issue with DEM-03 for sprint 2

Options
mohammed007
mohammed007
in Academy Discussions

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

mohammed

dem03.png

Best Answer

  • Venki9902
    Venki9902
    edited June 2023 Answer ✓
    Options

    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)


    Regards,
    Venkatesh

Answers

  • mohammed007
    mohammed007
    Options

    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,

Categories