Level 2: Model Builder - Inventory Ordering Module Formulas


Hi everyone,

I am not getting the results as expected. Does anyone of you know where my mistake is?

  1. for the first Row "Beginning Inventory" I am only getting values for Week 1.
  2. For row "Shipping Time Weeks" I am getting 0 as the result. But expected is the value 4 (for Week 1).

Here are my formulas:

Thank you.

KR Tobi


  • DeepakK
    edited March 1


    The formula looks correct. Do you have the necessary data in TRA01?

    For Beginning Inventory, what is the rest of that formula? It only shows up to the PREVIOUS

  • thoener

    Got it. Thank you :)