I work in consumer goods company. I am automating their procurement process on knime. I have configurated the part that calculates the quantites I need to order over the spam of 10 month.
However, in order to submit my first order I need to recpect a set of criterias:
1- For every supplier, the sum of the quantities of all the articles of that supplier needs to respect the minimum ordering quantities (MOQ) of the supplier:
If the sum of the articles I want to order in the first month doenâ€™t respect it, the monthly needs of the following months keep adding up until I reach the MOQ.
Example in Excel File attached. MOQ.xlsx (12.5 KB)

Thank you for your help. The model works. However, how can I please add the condition that if the quantity to be ordered of an article in the first month is 0 the model should not try to add up next monthâ€™s need it should automatically say â€śNOâ€ť and only aggregate (sum) next months needs if in the first month the quantities to be ordered are higher than 0. Because in the example I gave non of the demands was 0 but it turned out that it might be the case. In this example lets say kitkatâ€™s demand for first month was 0 the model shouldnâ€™t keep going forward with kitkat?

Hello @bruno29a
So what I am trying to say, is that in case the sum of the quantities to be ordered in the first month is 0, nothing should be ordered from that supplier and the model should stop and not keep adding next months until it reaches MOQ. MOQ.xlsx (14.4 KB)
I have added an example in the data with the company P&G. If the sum of the quantities to be ordered for P&G in the first month is 0, the system should not place an order for P&G:

So my need is to add something to this model so that it first checks if the sum of the quantities is 0 it doesnâ€™t place the order if its not zero then it start adding up next months until it reaches MOQ.

Hi @mehdi_zinbi , thank you for the data and the explanation.

I modified the workflow to bypass everything for the supplier if the sum for the first month is 0 for a supplier. I added an IF Switch to do this. I highlighted the changes here: