Configuring How Logical Operators Are Displayed

Filters can have multiple qualifications, which are the conditions (such as Revenue > 6,000,000) that the data must meet to be included in a report. A report can also contain multiple filters in its report filter. For example, a report filter contains two filters, East Coast Regions and Revenue > $6M. The filters are joined by a logical operator, which is AND in this case.

Use the following settings to configure how to display the logical operators that join multiple conditions:

• New line between conditions: Determines whether each condition is placed on a separate line. You can also select Automatic, which inserts a line only when conditions are joined by different logical operators.

  A report is filtered for revenue greater than $5 million and profit greater than $800,000 and the Northeast region. The filter details use the Automatic option for New line between conditions. Because the conditions are joined by the same logical operator (and), the conditions are displayed on the same line.

  

  A second report uses the same filter conditions, except the second logical operator is replaced by OR; the report is filtered for revenue greater than $5 million and either profit greater than $800,000 or the Northeast region. The New line between conditions option is still set to Automatic. A new line is started at the logical operator AND, and again before the second condition. Using the new lines helps to distinguish the conditions.

  

  • If you select Yes or Automatic, you can specify whether to Single space or Double space the conditions. Both examples above are single-spaced.
• Parentheses around conditions: Determines whether parentheses are placed around each condition, such as (Region = Northeast). If a new line is inserted between conditions, you can often omit the parentheses since the different conditions are already differentiated from each other.

  You can also select Automatic, which displays parentheses only when they resolve ambiguity in the expression. Parentheses are not included around conditions that are joined by the same logical operator. When conditions are joined by different operators, the parentheses are necessary to ensure that the conditions are grouped correctly.

  A report is filtered for revenue greater than $5 million, and either profit greater than $800,000 or the Northeast region. The filter details use the Automatic option for Parentheses around conditions. Parentheses are displayed because they ensure that the conditions are grouped and read correctly.

  

  A second report uses the same filter conditions, except the second logical operator is replaced by AND; the report is filtered for Revenue greater than $5 million and Profit greater than $800,000 and the Northeast region. The New line between conditions option is still set to Automatic. The filter details use the Automatic option for Parentheses around conditions. Because the conditions are joined by the same logical operator (AND), and there is no ambiguity about the order, parentheses are not used.

  

• Logical operator between conditions: Specifies whether to display the logical operator between conditions. The options are:
  • Yes to display all operators
  • No to omit all operators
  • AND only to display only the AND operator
  • OR only to display only the OR operator

  All the previous report samples showed all the operators, while the report sample below displays AND only. Notice that the OR before the Region condition is replaced by a comma.

  

  You can also choose to inherit these settings instead, as described in Levels of Report Details Configuration.