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

AbhijeetGarai
AbhijeetGarai
in Modeling

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

Tagged:

Answers

  • JaredDolich
    JaredDolich

    @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!

Categories