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

Question

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 Answer

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 · Accepted Answer

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