A Salesforce administrator is tasked with building a custom report on Support Cases grouped by Support Tier. The VP of Customer Support requires two specific metrics: evaluating the duration in days between Created Date and Closed Date for every individual case record, and calculating the percentage of closed cases for each Support Tier relative to the grand total of all closed cases. Which two formula configurations should the administrator implement to meet these business requirements?
- Add a row-level formula to the report that subtracts CreatedDate from ClosedDate to calculate duration on each record.Answer
- Add a summary formula using the PARENTGROUPVAL function to evaluate each Support Tier grouping against the grand total.Answer
- CAdd a summary formula to evaluate the difference between ClosedDate and CreatedDate for each case row in the report.
- DCreate a roll-up summary field on the Account object via its lookup relationship to Case to calculate individual case duration.
Answer
The administrator should add a row-level formula to compute the duration between ClosedDate and CreatedDate for each individual record, and use a summary formula with the PARENTGROUPVAL function to compare grouping totals against the grand total.
Row-level formulas execute record-by-record on report details, allowing administrators to subtract field values such as CreatedDate from ClosedDate for each case row. Summary formulas utilize functions like PARENTGROUPVAL to calculate ratios between specific grouping levels and grand totals.
Step-by-Step Solution
Key Concept
Distinction between row-level formulas and summary formulas (including PARENTGROUPVAL) in Salesforce reports.
Estimated Time:1m 30s