Hey Guys… I am having a issue with the following table
Arrival ----------- Acumulated Quantity ------ --------- Maximum Capacity -------- -Compute
100 ----------------------- 400 ---------------------------------------- 550 -------------------------Yes
100 ----------------------- 500 ---------------------------------------- 550 ------------------------- Yes
100 ----------------------- 600 ---------------------------------------- 550 ------------------------- No
100 ----------------------- 700 ---------------------------------------- 550 ------------------------- No
You see that a number X of producted arrived, overtaking the maximum capacity.
But part of X could be computed if i split the rows into two like that
Arrival ----------- Acumulated Quantity ------ --------- Maximum Capacity -------- -Compute
100 ----------------------- 400 ---------------------------------------- 550 -------------------------Yes
100 ----------------------- 500 ---------------------------------------- 550 ------------------------- Yes
50 ----------------------- 550 ---------------------------------------- 550 ------------------------- Yes
50 ----------------------- 600 ---------------------------------------- 550 ------------------------- No
100 ----------------------- 700 ---------------------------------------- 550 ------------------------- No
I am not sure how to do it Tho.
Can someone please help me?