A Salesforce Administrator at a commercial property management company is tasked with configuring an Account report for the regional operations team. The report must include accounts that meet the following criteria:
1. Account Rating is equal to 'Hot' OR Annual Revenue is greater than $10,000,000.
2. Account Type is equal to 'Commercial Tenant'.
The administrator creates the following field filters on the Account report:
Filter 1: Rating equals Hot
Filter 2: Annual Revenue greater than 10,000,000
Filter 3: Type equals Commercial Tenant
Which custom filter logic statement must the administrator apply to return only the records matching the business requirement?
- (1 OR 2) AND 3Answer
- B1 OR (2 AND 3)
- C1 AND 2 AND 3
- D1 OR 2 AND 3
Answer
The custom filter logic statement '(1 OR 2) AND 3' correctly groups the optional conditions in parentheses while enforcing the required account type condition.
Enclosing Filters 1 and 2 in parentheses creates a single logical evaluation unit for the disjunctive 'Hot rating OR high annual revenue' criteria. Combining this unit with AND 3 ensures that every returned account fulfills the mandatory Type requirement.
Step-by-Step Solution
Key Concept
Boolean filter logic parenthesization and operator precedence in Salesforce Reports