FILTER <>* *

I’m trying to create a filter that will exclude any values that include a certain piece of text (let’s say, SMITH).

In Excel the custom filter “Does Not Contain… SMITH” works.

In Navision, I’ve tried

<>SMITH

but it doesn’t exclude anything.

Can anyone help?

Thanks.

Hi

If you are using SQL server you may use the filter as you wrote it. Otherwise you should do the following:

  1. Show the entire list

  2. Select All

  3. Edit | MArk (Ctrl+F1)

  4. Filter SMITH

5 Remove mark (CTRL+F1)

  1. Remove filters

  2. View | Marked only

Best Regards

Alex

Excellent!

Thanks.