SYS01 DEM03

mstanisic
Contributor

SYS01 DEM03

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
anand.shekhawat
Super Contributor

Re: SYS01 DEM03

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

View solution in original post

2 REPLIES 2
anand.shekhawat
Super Contributor

Re: SYS01 DEM03

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

View solution in original post

mstanisic
Contributor

Re: SYS01 DEM03

Hi  Anand,

 

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

 

Best, 
Matthias