Bringing Text or Values to running balance with condition
I am looking for a solution where function assigns text like A or B or Values like 0 or 1 to the cumulative balance which are Falling to Zero. (I have done running cumulative balance using Peek)
May be below example should be explaining what i am trying to achieve. And i want to do this at Script level. The Field "Cumulative Balance" holds running balance and i would like to have result as shown in field "Expected result".
To keep it short: Solution i am looking is getting any text for all line items which are rolling to zero with condition that "COCODE" and "Assign" should be same.