I've entered the formula for the beginning inventory but it doesn't seem to work completely.

AbhijeetGarai
New Contributor

I've entered the formula for the beginning inventory but it doesn't seem to work completely.

Abhijeet_0-1636749164723.png

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

1 REPLY 1
JaredDolich
Moderator

@AbhijeetGarai 

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!


Jared Dolich