I have 2 variables MOQ and Forecast per month (each month is listed in a row) for a list of materials, I want to calculate how many months of forecast are covered by the MOQ and put the output in a new column. I want to subtract the MOQ by the cumulative forecast and count how many month for the subtraction result becomes zero.
Right now I have 2 tables one with the material, plant and MOQ and the 2nd one has material plant and forecast per month.
Hi @Nancy_Riad -
If I am understanding you correctly, it seems like you might first want to use a Joiner node to merge your two tables based on material and plant. Then, once you have a single table, you could use a GroupBy node to do counting, a Math Formula node to do subtractions, and so on.
Thank you for your help, what I want to do is a little bit different, or maybe I don’t understand your explanation . I don’t want to count the number of months with forecast, what I want to do is calculate how many months of forecast are covered by my MOQ.