Opportunity Aging Compliance calculates Opportunity Aging Compliance from Opportunities within age target and Open opportunities using the documented KPI relationship. Use values from the same scope and reporting period so the ratio is meaningful.
How to use this tool
Formula
Opportunity Aging Compliance = Opportunities within age target ÷ Open opportunities × 100
Input consistency
The numerator and denominator should describe the same population, time period or operating scope. The denominator must be greater than zero.
Worked example
80 ÷ 100 × 100 = 80%.
Examples
KPI example
80 and 100 produce 80% using the displayed formula.
Common use cases
- Calculate Opportunity Aging Compliance for one reporting period
- Compare scenarios using consistent definitions
- Check a spreadsheet or dashboard calculation
Frequently asked questions
What formula does Opportunity Aging Compliance use?
Opportunity Aging Compliance = Opportunities within age target ÷ Open opportunities × 100
What happens if the denominator is zero?
The denominator must be greater than zero; a zero denominator does not produce a meaningful ratio.
Why can this KPI differ between reports?
Results can differ when reports use different time periods, populations, exclusions or definitions for the numerator and denominator.