Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas

Options
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
    Options

    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
    Options

    Got it. Thank you :)

Categories