SYS01 DEM03

mstanisic
mstanisic
in Modeling

Hi Team, I am struggling with DEM03 and the SYS01 Time Settings by Week 

 

Firstly, in SYS01, 1st Forecast Year remains empty, please see attached the blueprint of the same and the associated formulae as well as the time settings view. 

 

This in turn I believe leads to DEM03 Demand forecast to be empty for Baseline Forecast. 

Alternatively, it is also possibly related to the time settings, which I enclose. 

 

May I have your thoughts please? I'm looking forward to hearing from you. 

 

Thank you, Matthias

 

 

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    Hi @mstanisic ,

     

    Kindly look at the formula, you are calculating the Yearvalue of 'Current Period?' line item. But your FY summary boolean for 'Current Period?' line item would be BLANK as summary is set to 'None' as seen in the screenshot. So set the summary of 'Current Period?' line item to 'Any' and you will get the booleans in place. Refer the screenshot below

    anandshekhawat_0-1623780768545.png

     

    I hope this helps.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • mstanisic
    mstanisic

    Hi  Anand,

     

    Thank you for sharing this solution, I really appreciate it. 

     

    Best, 
    Matthias

Categories