Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas

thoener
thoener
in Academy Discussions

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).
    image.png


Here are my formulas:

image.png

Thank you.

KR Tobi

Tagged:

Answers

  • DeepakK
    DeepakK
    edited March 1

    Hi,

    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
    thoener

    Got it. Thank you :)

Categories