alteryx Community

# Alteryx Designer Desktop Discussions

SOLVED

## Cancel the pair off which is coming as zero

8 - Asteroid

I have multiple transactions from salary and I have to figure out the pair which is sum is not equal to zero

From the example below:  Salary Id;123 => 7000+(-7000) = zero-> Eliminate

Salary Id 123 => 14200 + 2000+8800 = 25000 (which is equal to salary amount) -> Keep it

Same goes for                   Salary Id 789 => 789 => -2500 + (-2500 )= -5000 (which is equal to salary amount) -> keep it

Note: The Idea is to eliminate the pair which is coming as zero

 salary_Id Transaction salary 123 7000 25000 123 -7000 25000 123 14200 25000 123 2000 25000 123 8800 25000 123 -8000 25000 123 8000 25000 456 3800 8800 456 5000 8800 789 -2500 -5000 789 -2500 -5000

Output:

 salary_id Transaction salary 123 14200 25000 123 2000 25000 123 8800 25000 456 3800 8800 456 5000 8800 789 -2500 -5000 789 -2500 -5000
2 REPLIES 2
17 - Castor

Does this give you what you want?

Alteryx Alumni (Retired)

Hi @Sshasnk ,