Examkin

Question

Difficulty: MediumReport Filtering, Filter Logic, and Bucketing

A Salesforce Administrator at a regional commercial bank is configuring an Opportunity report for commercial loan applications. Management requires the report to categorize open loans into Low, Medium, and High risk tiers based on ranges from a numerical Risk Score field. Additionally, management wants to apply complex filter criteria that evaluate multiple stage conditions using custom Boolean grouping. Which two actions should the administrator take to fulfill these requirements using standard report capabilities? (Select TWO answers.)

  1. Create a Bucket Field on the numerical Risk Score field to segment loan records into Low, Medium, and High risk value ranges directly within the report.Answer
  2. Add Filter Logic to customize the Boolean evaluation order using parentheses, such as (1 AND 2) OR 3, across the report field filters.Answer
  3. C
    Create a Summary Formula Field to categorize individual loan application records into risk tiers before applying report filters.
  4. D
    Create a Roll-Up Summary Field on the User object to aggregate loan application totals and filter out inactive loan officers.

Answer

The administrator should create a Bucket Field on the numerical Risk Score field to define the Low, Medium, and High risk ranges, and use Filter Logic with parentheses to control the Boolean evaluation order of field filter criteria.
Creating a bucket field on a numerical field allows report-level grouping into designated ranges without custom field creation. Applying filter logic allows precise Boolean grouping of multiple report filter conditions using parentheses.

Step-by-Step Solution

1
Identify the requirement for categorizing numeric values into discrete tiers within the report.
Determine that a Bucket Field on the numerical Risk Score field allows defining ranges (e.g., 0-300 Low, 301-600 Medium, 601-900 High) without modifying object schema.
Bucket fields provide inline record categorizations for Numeric, Picklist, and Text fields in reports.
2
Identify the requirement for complex Boolean condition evaluation.
Add Filter Logic to specify custom operators and grouping parentheses like (1 AND 2) OR 3.
Standard report field filters evaluate sequentially as AND unless explicit Filter Logic is configured.

Key Concept

Report Bucketing and Filter Logic
Estimated Time:1m 30s
Rate this question

Topics

Report Filtering, Filter Logic, and Bucketing

More questions from this topic