issue with DEM-03 for sprint 2

Question

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

Venki9902 · Accepted 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)

Regards,

Venkatesh