SALES-CLOUD-CONSULTANT practice question 24 of 25

Universal Containers has implemented Salesforce for all of its sales reps. All sales reps are required to select the win or loss stage on every closed opportunity. Managers like to measure the win ratio for all of the sales reps. How should a consultant meet the requirement?

Full set: 190 questions
Answer options
A: Ensure that all managers have access to the standard Win report.
B: Build a custom report on Opportunity with custom summary formulas to show win ratio. Correct answer
C: Create 3 custom formula field on Opportunity to capture the win ratio for opportunities.
Correct Answer:
B. Build a custom report on Opportunity with custom summary formulas to show win ratio.
Explanation

The requirement is to calculate an aggregate metric—the win ratio—across a set of opportunity records for sales reps. The standard and most effective tool in Salesforce for such aggregate calculations is a report with a custom summary formula. This allows for the creation of a formula (e.g., WON:SUM / RowCount on a report filtered for closed opportunities) that dynamically calculates the ratio across the grouped records (e.g., by sales rep). This provides managers with a direct and accurate measurement without manual effort.

Why Incorrect

A. Ensure that all managers have access to the standard Win report. Standard reports show counts of won and lost deals but do not inherently calculate a ratio. This would require managers to perform manual calculations, failing to meet the requirement directly.
C. Create 3 custom formula field on Opportunity to capture the win ratio for opportunities. A formula field calculates a value for a single record. A win ratio is an aggregate metric across many records and cannot be calculated at the individual opportunity level.

References

1. Salesforce Help Documentation, "Calculate Ratios in Reports": This document provides a direct example of creating a win rate percentage. It states, "To find your sales team's win rate, create a summary formula that divides the number of won opportunities by the total number of opportunities closed." This confirms that a custom summary formula in a report is the correct method.

2. Salesforce Help Documentation, "Evaluate Reports with Formulas": This guide explains the different types of report formulas. It clarifies that "Summary formulas can be complex. You can build a summary formula that...calculates a percentage of a total." This distinguishes summary formulas, used for aggregate calculations like ratios, from row-level formulas.

3. Trailhead, "Reports & Dashboards for Lightning Experience" Module, "Use Summary Formulas and Bucket Fields" Unit: This educational module teaches that summary formulas are used to "calculate additional totals based on the numeric fields in your report." It provides examples of creating percentage calculations, which aligns directly with the requirement for a win ratio.

Scroll to Top