Level 2 Sprint 3 INV 01 Beginning Inventory Line item
I am getting a question in the Exam incorrect:
"In the Supply Chain model, INV01 Inventory Ordering module, enter the formula for the Beginning Inventory line item:"
I have tried both the below formulas, and get an incorrect result both times.
IF 'SYS01 Time Settings By Week'.'1st Week of Timescale' = FALSE THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
IF 'SYS01 Time Settings By Week'.'Not 1st week of Timescale?' = TRUE THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
The build instructions say the following:
- The syntax of the formula should be written - If it is not the first week of the year, then use the previous value of ending inventory, otherwise use the beginning inventory from DAT01 Beginning Inventory module.
I feel like both my formulas achieve the build instructions, and yet I am punished with an incorrect result - can anyone point out where I have gone wrong?