Examkin

Question

Difficulty: EasySummary and Row-Level Report Formulas

An administrator at Ursa Major Solar is creating a report on Accounts to evaluate whether each individual record meets a specific threshold based on its Annual Revenue field. The calculated output must be displayed directly on each detail row in the report without creating a custom field on the Account object schema. Which reporting feature should the administrator use to fulfill this requirement?

  1. Create a row-level formula in the report builder to evaluate the Annual Revenue of each record.Answer
  2. B
    Create a summary formula utilizing PARENTGROUPVAL to evaluate individual record values.
  3. C
    Create a roll-up summary field on a lookup relationship to calculate record values dynamically.
  4. D
    Create a custom summary formula to calculate row values across un-grouped detail rows.

Answer

Create a row-level formula in the report builder to evaluate the Annual Revenue of each record.
Row-level formulas in Salesforce reports allow administrators to write logic that evaluates each individual record row in the report dataset, satisfying the requirement without creating custom fields on the Account object.

Step-by-Step Solution

1
Identify the evaluation scope required by the scenario.
The requirement calls for a calculation executed on each individual detail row in the report.
Record-by-record logic requires a row-level formula rather than an aggregate summary formula.
2
Determine the appropriate Salesforce report feature.
A row-level formula in the report builder evaluates field logic row by row without adding custom fields to the underlying object schema.
This directly solves the business requirement while adhering to object customization constraints.

Key Concept

Distinction between row-level formulas and summary formulas in Salesforce reports
Rate this question

Topics

Summary and Row-Level Report Formulas

More questions from this topic