Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Every month i take a snapshot of the quantity and amount in stock for each article.
This week i added them together in one table and we found that stocklevels were dropping more than we were aware of.
I added the incoming purchased stock to have an idea of how soon stocklevels would be ok again.
Now in the table above i would like to add the current stock to the amount cumming in for the next months, but also only starting from today.
And i'm not sure how to write this expression.
Who can help me?
thanx!
Chris
its a bit complicated to infer the business rules just looking at the picture. is it possible to create a table of current and incoming and the desired output per month? this will also give us an idea what the fields are
this will help other help you
its a bit complicated to infer the business rules just looking at the picture. is it possible to create a table of current and incoming and the desired output per month? this will also give us an idea what the fields are
this will help other help you
Hello,
your answer got me thinking.
When loading the stock data, i added the current date to that load and then i could combine the stock data between the historical situation and future incoming stock.
thanx
Chris