Confining Rolling Sum to a Specific Number

[MD2050]

Hello -

we have a work schedule which is split by "BatchFlag" , we need to confine the SumQty to 100 so if a batch is less then 100 then it should add units form subsequent "same" batch row and round it to 100 and move the remainder quantity to the next "same" batch making sure that the cumulative sum of that particular batch remains same. 

I am trying to add a multi-row logic to add a new variable "batch" # based on the batch flag and then check the SumQty for 100 ; if <100 then add from next batch row. Unfortunately i am not able to get around the logic of not adding if sumqty>100 and leave the SumQty as-is. 

left snippet shows what i am working with , right snippet shows the data and "Required" column shows the desired output. 

Thank you for helping. 

[MD2050]

Please find in attached. The only difference was i fed summarized data (yxmd) to the WF I sent earlier while testing my logic . 

Thank you,

md.