Filter Account Pairing Plus Interface Tool

[Gamaliel]

Hello Great Alteryx Users,

I am seeking help with this one. I want to filter JE Identifiers which have debits (positive in net amount) for asset (from the account type column) and credits (negative in net amount) for expense. E.g. 001 should be filtered because it has a debit to asset and a credit to expense.

Furthermore, please also help me in connecting an interface tool to it that will give me more choices (e.g. debit to liability and credit to revenue). 

IN addition, I do not know if I made the proper workflow in the attached app. Thanks 

Please see attached.

[Gamaliel]

Hello @atcodedog05 ,

I am afraid we are not finished yet 🙂 There is an error here. For debit asset and credit expense and testing above 50,000, there should be no result.

Thanks.

[atcodedog05]

Hi @Gamaliel 

Since the type is "Credit - Liability" which is not selected in filter threshold is not applied on it.

[Gamaliel]

@atcodedog05 , I am attaching another workflow here . 🙂 I made this by referring to your techniques. Thanks for helping.