Please refer my Screenshots. I am unable to deduce why except for week 1 , no other cells are getting populated when I use the formula "IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory".
Could this be backtracked to something I missed in earlier lessons? Stuck on this for sometime now.