Allocate negative amounts to same product row problem

[gjunhao96]

Hi all,

Suppose i have a dataset as such: 

What I want to do is for each row with a negative amount, I want to add that amount to a row of the same product with a positive amount, and identify any negative amount that has been unallocated. The output could be something like this:

How could I achieve this? Initially, i thought that a multi row formula tool might work, but seems like i have to both look at above and below rows. Attached is a starter workflow file.

[Emmanuel_G · Accepted solution]

Hi @gjunhao96 ,

Find attached the way of doing this.

Please do not hesitate to mark this answer as solution if it helped.

[FrederikE · Accepted solution]

Hey @gjunhao96,

See the attached WF