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 :)
Solved! Go to Solution.
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 : )
Hi @MATTHEW_KING1 I mocked up some examples when using value Not In using a filter let me know what you think?
@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.
thanks @atcodedog05 and @JosephSerpis