web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Entering Criteria in F...
Small and medium business | Business Central, N...
Answered

Entering Criteria in Filters

(1) ShareShare
ReportReport
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

Not-Either-Or-a.jpg

I tried below two options with no success

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

<>20600A|20500|20600

Many thanks

Louise

I have the same question (0)
  • Suggested answer
    Amit Profile Picture
    Amit 2,557 on at
    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.

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,688 Moderator on at
    RE: Entering Criteria in Filters

    Hi,

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

  • Verified answer
    YUN ZHU Profile Picture
    YUN ZHU 92,886 Super User 2025 Season 2 on at
    RE: Entering Criteria in Filters

    Hi, Amit is right.

    For example,

    <>10000&<>20000

    pastedimage1672809614953v1.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Lovisa LH Profile Picture
    Lovisa LH 29 on at
    RE: Entering Criteria in Filters

    Thank you Amit!

  • Lovisa LH Profile Picture
    Lovisa LH 29 on at
    RE: Entering Criteria in Filters

    Thanks Zhu.

    And Happy New Year to you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,255

#2
Sumit Singh Profile Picture

Sumit Singh 2,665

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,401

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans