Good afternoon everyone, how are you?
I have a calculation challenge, in short, where capacity is 0, the forecast needs to be added for the next day or the previous day. I will pass the cases 1 by 1 to you.
Case number 1:
On 10/30 I have a forecast of 12729 and a capacity of 0. Therefore, this value must be added for the next day, 10/31
Case number 2:
On 10/30 I have a forecast of 14263 and a capacity of 0. Therefore, this value must be added for the next day, 10/31, but on that day my capacity is also 0, so the values must be added for the day 01/11.
case number 3:
On 10/30 we have a forecast of 2231 and capacity 0, it is the same as case number 1. However, on 11/02 we have a forecast of 8554 and 0 capacity, this value must be added to 11/03.
NOTE: This case could possibly be included in case number 1, but I thought it was important to highlight the possibility.
case number 4:
On 04/10 we have the forecast of 19703 and capacity 0, and it is the last day of the week, we do not have 05/10. In this case it must be added to the previous day on 10/03.
case number 5:
All days do not have Capacity so they can be deleted.
KNIME_project - Somase.knwf (54.1 KB)
