Vertical match

[KarenHM]

Hi Community

I need to eliminate the amounts that in "amount ARS" and Source "Constab" is zero, in the follow image you can see what amount i want to eliminate.

Thanks 

[Robin_McIntosh]

Will it always be 1-to-1?  Meaning the + and - are the same amounts?

Or could there be multiple lines to equal out to zero?

And does it have to be on the same date or can be different?

[KarenHM]

Hello Robin 

yes , appear + and - because is the entry and the reverse in the same period or not. so that means could be in different date. 

thanks 

[Robin_McIntosh · Accepted solution]

So if always 1-to-1 then this will get what you need.  You may need to adjust your Group By based on what is the same between entries.

[KarenHM]

Thanks Robin , your solution is perfect.