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

[ll98]

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.

[JulioMO · Accepted solution]

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]

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 · Accepted solution]

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")