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 Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Using the Formula tool or Filter Tool to exclude a number of GL Accounts to Show

ll98
9 - Comet

I have a number of GL Accounts to exclude from the output of a Trial Balance

 

For instance, if I have the following GL Accounts  :  100 , 200 , 210, 300, 500 , 510 , 600 , 610, 650, 700    But I just want to exclude account 200, 510 and 610 .   How do I create a filter for it .

 

I try  [GL Account]  != "200", "510", "600"   but that did not work...   I think I'm doing the incorrect logic here.

3 REPLIES 3
JulioMO
9 - Comet

Hi @ll98 

 

In the Filter Tool, try this: 

 

If the column is set as a text column: 

[GL Account]  != "200" AND [GL Account]  != "510" AND [GL Account]  != "600"

 

If it is set as a number column: 

[GL Account]  != 200 AND [GL Account]  != 510 AND [GL Account]  != 600

 

Regards

ll98
9 - Comet

The value is a number -- so I have it as Fixed Decimal --- 

 

It works like this -- but how can I add more GL accounts to the filter

!Contains([GL Account],"0400")

ll98
9 - Comet

Finally -- thru trial and error ... got it to work

 

Needed to do it like this ... I thought I could just put comma's between the elements

Thanks for your guidance

 

!Contains([GL Account],"0400") and

!Contains([GL Account],"0450") and
!Contains([GL Account],"0500") and
!Contains([GL Account],"0600") and
!Contains([GL Account],"0920") and
!Contains([GL Account],"0925") and
!Contains([GL Account],"0940") and
!Contains([GL Account],"0950")