Filtering out customer numbers using filter tool

[MATTHEW_KING1]

Hi, i need to filter out certain customer numbers coming from my input, i believe i used a filter tool previously, but cannot get this to work. Can anyone please assist? I think its possible using NOT IN but i can't remember how :)

[atcodedog05]

Hi @MATTHEW_KING1 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[JosephSerpis]

Hi @MATTHEW_KING1 I mocked up some examples when using value Not In using a filter let me know what you think?

[MATTHEW_KING1]

@atcodedog05 Please see attached. So if i wanted to exclude 12345 and 33556 how would that be achieved using the NOT IN function on the filter tool please? I tried 

[Cust no] NOT IN ("12345")

But the formula seems to go invalid once i add the last parentheses.

[atcodedog05 · Accepted solution]

Hi @MATTHEW_KING1 

Since its not a number don't use quotes like below

Hope this helps : )

[MATTHEW_KING1]

thanks @atcodedog05  and @JosephSerpis