Examkin

Question

Difficulty: EasySummary and Row-Level Report Formulas

A sales manager needs to calculate a discounted value for every individual line item record in an Opportunity report by multiplying the Opportunity Amount by a custom discount percentage field. Which reporting capability should the administrator configure to calculate this value record by record?

  1. A row-level formulaAnswer
  2. B
    A summary formula
  3. C
    A roll-up summary field
  4. D
    A PARENTGROUPVAL summary function

Answer

The administrator should use a row-level formula because it executes logic on each individual record line displayed in the report.
A row-level formula is specifically designed to perform calculations on each individual record displayed within a report run.

Step-by-Step Solution

1
Identify the requirement scope
The calculation must take place on every individual record line (record-by-record level).
Understanding whether data needs individual evaluation or group aggregation determines the correct formula tool.
2
Select the appropriate reporting tool
Choose a row-level formula.
Row-level formulas allow administrators to compute custom calculated fields for each detail row in a report without creating custom schema fields.

Key Concept

Row-Level Formula vs Summary Formula Scope
Estimated Time:45s
Rate this question

Topics

Summary and Row-Level Report Formulas

More questions from this topic