topic Using the Formula tool or Filter Tool to exclude a number of GL Accounts to Show in Alteryx Server Discussions

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

ll98 — Fri, 19 Feb 2021 04:41:30 GMT

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.

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

JulioMO — Fri, 19 Feb 2021 12:57:01 GMT

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

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

ll98 — Fri, 19 Feb 2021 14:51:45 GMT

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

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

ll98 — Fri, 19 Feb 2021 15:09:51 GMT

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