Can anybody please help with what is wrong in the formula?
IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
OH! You did it! this is the right equation. The reason why other weeks don't populate is because you haven't entered the Ending Inventory values yet. Beginning Inventory will appear once you finish all the formulas.
Good job! Nicely handled!