Level 2 Sprint 3 INV 01 Beginning Inventory Line item

Options
Cwr100
Cwr100 Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor
in Anaplan Community

All,

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?

 

Chris

Comments

  • Cwr100
    Cwr100 Member, ALL USERS, Certified Model Builder Posts: 4 Occasional Contributor

    Thanks, that did the trick

Categories