Filter Logic

Filter Logic

Objectives

  1. Understand what Filter Logic is and when to use it
  2. Understand how to add Filter Logic to your reports

What is Filter Logic?

If you have more than one filter in a report, adding filter logic will let you specify conditions for your filters  to group, partition, and even exclude filter elements from a report with everyday language like AND, OR and NOT. When you add filters to a report, by default, all filters are related as AND logic.

All your report filters will be numbered. Your first filter is Filter 1 and your second filter is Filter 2. You apply filter logic based on these numbers. 

The three filter logic operators are:
  1. AND: Finds records that match both values
  2. OR: Finds records that match either value 
  3. NOT: Finds records that exclude values
For example:  You would like a report on all MYCE Quote type = Groups with a Closed status not equal to Lost, Cancelled, Refused and with either a revenue greater or equal to 10.000 EUR or a number of Pax greater or equal to 100. 
Filter 1 = Type equals Groups
Filter 2 = Closed status not equal to Lost, Cancelled, Refused
Filter 3= Total Amount excluding Tax greater or equal 10.000€
Filter 4= Pax greater or equal 50
Your filter logic will be 1 AND 2 AND (3 OR 4)

How to add Filter Logic to Reports 

1. From your report, click on 'Filters' 
2. Click the down arrow
3. Select 'Add Filter Logic'



4. By default all filters will be related as AND logic (1). You can edit the logic depending on your requirements (2). 



5. Click on 'Apply' when done.

    • Related Articles

    • How to Build a Report

      Objectives Gather the information needed to build a report Create a new report using the Report Builder Report Requirements When you create a report, the criteria you enter is essentially a question you are asking, and the results returned are the ...
    • Overview: Reports & Dashboards

      Objectives       Understand the differences between report, dashboard and report type.  Get familiar with Report and Dashboards features and concepts.  Reports and Dashboards provide the answers to the questions which are important for an ...
    • How to Edit a List View

      As a salesforce user, you can create and edit your List Views by adding or removing columns and specifying criteria.  On the Home Page, click on 'Accounts' and a list of 'Views' will appear. Here click on the List View that has been created but you ...
    • Kanban

      Thanks to the Kanban view, discover a visual summary for a selection of records.It will help you to work efficiently and keep your deals moving forward. What is a Kanban? A Kanban is a visual system managing your work in the course, gathering your ...
    • How to Create an Email Template

      What is an email template?  Email templates are amazing tools to help you save time, engage with contacts on a regular and personalised way, and ensure consistency in your communication to clients.  There are two ways to create email templates in ...