Percentage of Partners Calculator for Sales

Calculator Inputs

Example Data Table

This sample table shows how different partner groups compare across sales scenarios.

Scenario	Total Partners	Selected Partners	Active Partners	Sourced Partners	Total Revenue	Selected Revenue	Selected %
North Region	120	42	68	35	$300,000	$126,000	35.00%
Channel Expansion	95	28	51	22	$210,000	$73,500	29.47%
Strategic Alliance	60	18	33	15	$140,000	$56,000	30.00%
Referral Program	150	54	84	46	$360,000	$151,200	36.00%

Formula Used

Selected Partner Percentage
(Selected Partners ÷ Total Partners) × 100

Remaining Partner Percentage
((Total Partners - Selected Partners) ÷ Total Partners) × 100

Active Partner Rate
(Active Partners ÷ Total Partners) × 100

Sourced Partner Rate
(Sourced Partners ÷ Total Partners) × 100

Revenue Share Percentage
(Selected Partner Revenue ÷ Total Partner Revenue) × 100

Target Partner Count
(Target Percentage ÷ 100) × Total Partners

Additional Partners Needed
max(0, ceil(Target Partner Count) - Selected Partners)

Average Revenue per Selected Partner
Selected Partner Revenue ÷ Selected Partners

How to Use This Calculator

Enter the full number of partners in your sales ecosystem.
Provide the partner count for the group you want to measure.
Enter active and sourced-deal partner counts for performance context.
Add total partner revenue and selected partner revenue values.
Set your target percentage to compare current coverage against plan.
Click Calculate Percentage to show the results above the form.
Review the graph, compare rates, and export the output as CSV or PDF.

Frequently Asked Questions

1. What does this calculator measure?

It measures the share of a chosen partner group against total partners. It also shows active rate, sourced rate, revenue share, target gap, and added partner needs for planning.

2. When should sales teams use it?

Use it during channel reviews, quarterly business planning, territory assessments, and partner program audits. It helps teams quantify representation and compare actual coverage against targets.

3. What is a selected partner group?

A selected group is the subset you want to evaluate. Examples include strategic partners, referral partners, enabled partners, certified partners, or partners from a single region.

4. Why include revenue fields?

Revenue fields show whether the measured partner group contributes proportionally. A group may represent a small count share but still drive a large revenue share.

5. What does the target percentage do?

The target percentage converts strategy into a required partner count. It shows whether current representation is ahead, on track, or below the desired channel mix.

6. Can this calculator support partner segmentation?

Yes. You can run it for different partner categories and compare outputs. This helps prioritize enablement, recruitment, retention, and co-selling efforts by segment.

7. What if selected partners exceed active partners?

That can happen if your selected group and active group are defined differently. Review your definitions to keep the comparison meaningful across reports and dashboards.

8. Can exported files be shared with leadership?

Yes. The CSV file supports spreadsheet analysis, while the PDF file is useful for quick reporting, reviews, and executive updates from the same results.