Question

Difficulty: EasySummary and Row-Level Report Formulas

A Salesforce administrator is building a report to track sales pipeline metrics and needs to understand the differences between report formula types. Which two statements accurately describe the capabilities of row-level formulas and summary formulas in Salesforce reports? (Select 2)

  1. Row-level formulas evaluate logic record-by-record on individual rows in a report.Answer
  2. Summary formulas evaluate aggregated data and require at least one grouping in the report.Answer
  3. C
    Summary formulas can be used to perform line-item calculations on un-grouped detail rows.
  4. D
    Roll-up summary fields can be created on standard objects to aggregate detail records linked through a lookup relationship.

Answer

Row-level formulas evaluate logic record-by-record on individual rows, and summary formulas evaluate aggregated data requiring at least one report grouping.
The correct options accurately identify that row-level formulas calculate values on a record-by-record basis, while summary formulas calculate aggregate metrics across grouped report data.

Step-by-Step Solution

1
Identify row-by-row evaluation capability
Determine that row-level formulas operate on individual records.
Row-level formulas calculate custom values for each row without requiring report groupings.
2
Identify aggregate summary evaluation capability
Determine that summary formulas operate on summarized data.
Summary formulas calculate metrics based on grouped subtotals or grand totals in reports.

Key Concept

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