Inventory calculation

KNIME Analytics Platform
#1

Hi, all, please your help

I am calculating an inventory based on orders and dispatch, the calculations is like below table:

image

I already have the first inventory but I need to calculate the inventory for the next weeks based on the first inventory(previous week) + orders(next week) - dispatch (next week)

I have spent a lot of time with this calculate but I can´t figure out how to do it :frowning:

#2

hi @BrandonBasurto
This is my suggestion
immagine
Two inputs:

  • the current value of Inventory (a variable)
  • the table with just Orders and Dispatch values
    immagine

Output
immagine

KNIME_project.knwf (10.8 KB)

1 Like
#3

Hi @duristef

That´s working! exactly what I need
Thank you so much

1 Like
#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.