Examkin

Question

Difficulty: Very hardReport Filtering, Filter Logic, and Bucketing

An Administrator at Northern Trail Outfitters is building an Opportunity report to evaluate deal velocity across sales regions. The sales leadership team specifies the following requirements for the report:
1. The report must include Opportunities where the Stage is either 'Proposal/Price Quote' or 'Negotiation/Review'.
2. The Opportunity Amount must exceed $100,000, OR the deal Probability must be greater than 75%.
3. The report must exclusively include Opportunities associated with Accounts that have at least one active Support Contract child record.
4. Deals must be categorized into custom market tiers ('Enterprise', 'Mid-Market', 'SMB') based on a custom currency formula field, `Calculated_Annual_Revenue__c`.

When attempting to build the report, the administrator notices that `Calculated_Annual_Revenue__c` is unavailable when creating a Bucket Field, and is unsure how to structure the filters. Which set of actions will successfully fulfill all reporting requirements?

  1. Set field filter logic to (1 OR 2) AND (3 OR 4) for the stage, amount, and probability filters; add a Cross Filter for Accounts WITH Support Contracts filtered by Status equals Active; and create a Row-Level Formula field on the report to group records into market tiers based on Calculated_Annual_Revenue__c.Answer
  2. B
    Set field filter logic to (1 AND 2) OR (3 AND 4) for the stage, amount, and probability filters; add a Cross Filter for Accounts WITH Support Contracts filtered by Status equals Active; and create a Bucket Field directly on Calculated_Annual_Revenue__c to categorize records into market tiers.
  3. C
    Set field filter logic to (1 OR 2) AND (3 OR 4) for the stage, amount, and probability filters; add a standard Field Filter for Account Support Contract Status equals Active; and create a Bucket Field directly on Calculated_Annual_Revenue__c to categorize records into market tiers.
  4. D
    Set field filter logic to 1 OR 2 AND 3 OR 4 without parentheses; add a Cross Filter for Accounts WITHOUT Support Contracts filtered by Status not equal to Active; and create a Row-Level Formula field on the report to group records into market tiers.

Answer

Configure filter logic as (1 OR 2) AND (3 OR 4), apply a Cross Filter of Accounts WITH Support Contracts (Status = Active), and use a Row-Level Formula to categorize the custom formula field.
The correct solution accurately pairs parenthesized filter logic ((1 OR 2) AND (3 OR 4)) with a Cross Filter (Accounts WITH Support Contracts where Status = Active) and leverages a Row-Level Formula because Salesforce Bucket Fields cannot be created directly on formula fields.

Step-by-Step Solution

1
Evaluate Boolean Filter Logic requirement
Filters 1 (Stage = Proposal) and 2 (Stage = Negotiation) must be grouped with OR: (1 OR 2). Filters 3 (Amount > 100k) and 4 (Probability > 75%) must be grouped with OR: (3 OR 4). Combining them requires AND: (1 OR 2) AND (3 OR 4).
Without explicit parentheses, Salesforce evaluates AND operators before OR operators, which alters the intended logic.
2
Evaluate Child Object Filtering requirement
Add a Cross Filter on the Opportunity report: 'Accounts WITH Support Contracts' and add a secondary sub-filter 'Status equals Active'.
Cross Filters allow filtering a primary object based on the presence or absence of related child records and child record attributes.
3
Evaluate Bucketing vs Row-Level Formula requirement
Use a Row-Level Formula field instead of a Bucket Field.
Salesforce Bucket Fields support Picklist, Text, and Number fields, but CANNOT be created on Formula fields. A Row-Level Formula must be created to evaluate `Calculated_Annual_Revenue__c` row by row.

Key Concept

Report Filter Logic, Cross Filters, and Bucket Field Limitations
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic