Examkin

Question

Difficulty: Very hardSummary and Row-Level Report Formulas

A Salesforce System Administrator at Cloud Kicks is designing an Opportunity report grouped by Account Name and Opportunity Stage. The business requires two specific calculations within the report:
1. Evaluating the elapsed duration in days between Created Date and Close Date for each individual opportunity record.
2. Calculating the percentage of total opportunity amount contributed by each Stage grouping relative to the parent Account Name grouping total.

Which two statements accurately describe the correct technical approach to fulfill these reporting requirements? (Select 2)

  1. A row-level formula must be created on the report to calculate the duration in days between Created Date and Close Date for each individual record.Answer
  2. B
    A summary formula should be configured to evaluate the duration in days between Created Date and Close Date for each individual opportunity record before grouping occurs.
  3. A summary formula utilizing the PARENTGROUPVAL function must be created to calculate the percentage contribution of each Stage relative to its parent Account Name grouping.Answer
  4. D
    A custom roll-up summary field should be created on the Account object via its lookup relationship to Opportunities to calculate the stage contribution percentage for the report.

Answer

To satisfy the requirements, the administrator must create a row-level formula for the individual record duration calculation and a summary formula utilizing the PARENTGROUPVAL function to evaluate the stage subtotal percentage relative to the parent account grouping.
The solution requires two distinct report formula types based on evaluation context. First, evaluating record-level date differences requires a row-level formula because row-level formulas process individual detail records. Second, computing the ratio of a subgroup subtotal to its parent group total requires a summary formula with the PARENTGROUPVAL function, which explicitly references parent grouping values in report structures.

Step-by-Step Solution

1
Analyze requirement 1 (record-level duration in days).
Since the calculation must be evaluated for each individual opportunity record row, a row-level formula is required.
Row-level formulas calculate values on detail rows record-by-record, whereas summary formulas only evaluate aggregated group rows.
2
Analyze requirement 2 (subgroup stage amount relative to parent account total).
Because this calculation compares a subgroup summary to its parent group summary, a summary formula using PARENTGROUPVAL is required.
PARENTGROUPVAL retrieves aggregated metric values from a specified parent group level to compute ratios or proportions across report hierarchy levels.
3
Evaluate distractor configurations against Salesforce platform limits.
Summary formulas cannot be used on detail rows, and roll-up summary fields cannot be created across lookup relationships.
Summary formulas lack detail row context, and declarative roll-up summary fields strictly mandate a master-detail relationship structure on standard/custom objects.

Key Concept

Distinguishing Row-Level vs. Summary Formulas and PARENTGROUPVAL Grouping Calculations
Rate this question

Topics

Summary and Row-Level Report Formulas

More questions from this topic