How to remove 2 of 3 lines that are offsetting entries

[ELPC]

Hi all, 

I have data that are General Ledger journal entries.  You may have a payment and then a reversal if something was posted incorrectly and then a reposting.  So essentially you have a positive, then negative, then positive again.  What I want to do is take out the first positive and negative records since those were offsetting and just keep the remaining last entry in the data set. If there are only 2 entries (1 positive and 1 negative) then I want to just remove this offsetting set of entries. 

I can figure out how to get rid of the 2 entries that are offsetting, I just can't figure out how to get rid of 2 when there are 3 entries (positive, negative, positive).  

Requirement: Only remove if all the other fields are exact matches.  

I have attached my sample workflow 

Thanks for the help. 

[fmvizcaino]

Hi @ELPC ,

Does the order matter? For instance, you have some lines where you have negative value, then 2 positives. Is it the same?

Also, what happens to those cases where you have more than 3 lines? 2 negatives and 4 positives, for example.

Best,

Fernando Vizcaino

[Qiu]

@ELPC 
I do hope there is a better or smarter way 😊

[courtklinger]

This workflow uses the unique tool and the summarize & remove offset. Not sure it is better than the other response, but it is easy to follow because it is the same thing over & over.