Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to filter for rows with values that offset each other in different rows?

overhead_press
8 - Asteroid

How do I filter for data that have values that cancel each other out grouped by the Account number? 

 

For example, the first two rows meet the criteria because they both belong to the same account, have the same values in Debit (Positive) and Credit (Negative) which equals to zero. Whereas the third row doesn't meet the criteria because there isn't a 200 credit amount in Account 1 to cancel it out. Thanks in advance!

 

Original:

Account DebitCreditNet Amount (Debit - Credit)
1100 100
1 100-100
1200 200
2 200-200
2 300-300
3300 300
3 300300

 

Desired result:

 

Account DebitCreditNet Amount (Debit - Credit)
1100 100
1 100-100
3300 300
3 300-300

 

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@overhead_press 
How about Account #2, it has many credits, when bing filtered out?

overhead_press
8 - Asteroid

So not for account 2 because they don’t have a debit amount in the same account to offset it. 

overhead_press
8 - Asteroid

So not for account 2 because they don’t have a debit amount in the same account to offset it. So for example there would need to be one transaction of 200 and one for 300 in the debit column for account 2 for it to show up in the output.

Christina_H
14 - Magnetar

This should do it

Christina_H_0-1637313197298.png

 

Labels