Examkin

Question

Difficulty: HardSummary and Row-Level Report Formulas

An administrator is building a custom report on Opportunities grouped by Region (Primary Grouping) and Sales Rep (Secondary Grouping). The business requires two specific metrics in the report layout: first, calculating the exact duration in days between the Created Date and Close Date for each individual opportunity record; second, calculating the percentage contribution of each Sales Rep's total won amount compared to their overall Region's total won amount. Which combination of report formula features should the administrator implement?

  1. Create a Row-Level Formula to calculate the record duration in days, and a Summary Formula utilizing the PARENTGROUPVAL function for the regional percentage contribution.Answer
  2. B
    Create a Summary Formula to calculate the record duration in days, and a Row-Level Formula utilizing the PARENTGROUPVAL function for the regional percentage contribution.
  3. C
    Create a Roll-Up Summary field on the parent object for the record duration calculation, and a Summary Formula utilizing PREVGROUPVAL for the percentage contribution.
  4. D
    Create a single Row-Level Formula to calculate both the record duration and the regional percentage contribution by referencing parent summary totals.

Answer

The correct approach is to create a Row-Level Formula to calculate the duration in days for each individual opportunity record, and a Summary Formula using the PARENTGROUPVAL function to compute the percentage contribution of each Sales Rep relative to their parent Region total.
Row-Level Formulas operate on individual record rows to compute values such as elapsed time between two date fields on a record. In contrast, calculating the ratio of a subgroup total to its enclosing parent group total requires a Summary Formula using the PARENTGROUPVAL function, which specifically retrieves summary values from specified parent grouping levels.

Step-by-Step Solution

1
Identify the record-level calculation requirement
Determined that calculating duration per individual record requires evaluating fields on single rows before summary aggregation.
Row-Level Formulas allow single-record calculations directly within report outputs (e.g., CloseDate - DATEVALUE(CreatedDate)).
2
Identify the group-level aggregation requirement
Determined that comparing a subgroup total to a higher-level parent group total requires summary aggregation functionality.
The PARENTGROUPVAL summary function calculates values from a parent group level relative to a child group level in grouped reports.
3
Combine the appropriate formula types
Selected a Row-Level Formula for the record-by-record date subtraction and a Summary Formula using PARENTGROUPVAL for the group ratio.
This combination respects Salesforce reporting limits and capabilities for detailed versus aggregated calculations.

Key Concept

Distinction between Row-Level Formulas (individual record evaluations) and Summary Formulas with PARENTGROUPVAL (group-level aggregations).
Estimated Time:2m 0s
Rate this question

Topics

Summary and Row-Level Report Formulas

More questions from this topic