Filter help - new user

[mikedesena]

I am a new user, so I thank you for your patience. I am trying to use a filter to display 4 rows in a data set based on exact account descriptions. I am trying to use the filter and OR but it is only filtering to the first record I am looking for.  I am trying to use the custom filter and typing in the following formula:

[F1] == "Total Property, Plant & Equipment"
OR "Capitalized Non-Network Software Fees"
OR "Customer Lists"
OR "Other Intangibles"

If I do them individually it runs as expected. Once I try to do the OR statements, I only get the first item in the formula. Can anyone please help me? I have read the filter help and thought I set this up properly. All advice is welcome. Thank you

[Claje · Accepted solution]

Welcome to Alteryx and the Community!

Alteryx filters are very powerful and can run on a wide variety of different fields at once.

Because of this, your filter isn't quite specific enough.

If you include [F1] = after the word OR in each of these you should be all set.

EG:

[F1] == "Total Property, Plant & Equipment"
OR [F1] = "Capitalized Non-Network Software Fees"
OR [F1] = "Customer Lists"
OR [F1] = "Other Intangibles"

[Kenda]

@mikedesena Try this:

[F1] = "Total Property, Plant & Equipment"
OR [F1] = "Capitalized Non-Network Software Fees"
OR [F1] = "Customer Lists"
OR [F1] = "Other Intangibles"