News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Entering Criteria in F...

Small and medium business | Business Central, N...

Answered

Entering Criteria in Filters

(1) Share

Report

Report

Posted on by Lovisa LH

29

Hello Colleagues and Happy New Year!

I have a question that i think is simple.

When entering criteria in filters in Nav 2018, how can I choose Not Either/Or?

Here I have filter for Either Or, which works. But I want to filter the list and include none of these three

I tried below two options with no success

<>20600A|<>20500|<>20600

<>20600A|20500|20600

Many thanks

Louise

All responses Img

All responses (5)

Answers Img

Answers (2)

Lovisa LH 29 on at

Like (1)

Report

RE: Entering Criteria in Filters

Thanks Zhu.

And Happy New Year to you!
Suggested answer

Lovisa LH 29 on at

Like (0)

Report

RE: Entering Criteria in Filters

Thank you Amit!
Verified answer

YUN ZHU 83,301 Super User 2025 Season 1 on at

Like (0)

Report

RE: Entering Criteria in Filters

Hi, Amit is right.

For example,

<>10000&<>20000

Hope this helps as well.

Thanks.

ZHU
Suggested answer

Nitin Verma 21,548 Moderator on at

Like (0)

Report

RE: Entering Criteria in Filters

Hi,

As per your image it works with OR, also you can go with Amit.
Verified answer

Amit_Sharma 2,547 on at

Like (1)

Report

RE: Entering Criteria in Filters

Hi,

use the below pattern

<>20600A&<>20500&<>20600

Regards
Amit Sharma
www.erpconsultors.com
www.gkscientist.com
www.linkedin.com/.../
Press Yes if info is useful.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

Sohail Ahmed 1,063

#2

YUN ZHU 1,002 Super User 2025 Season 1

#3

Mansi Soni 780

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans