Lost Value per Lost Deal calculates Lost Value per Lost Deal from Lost opportunity value and Lost deals 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
Lost Value per Lost Deal = Lost opportunity value ÷ Lost deals × 1
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 × 1 = 0.8 value/lost deal.
Examples
KPI example
80 and 100 produce 0.8 value/lost deal using the displayed formula.
Common use cases
- Calculate Lost Value per Lost Deal for one reporting period
- Compare scenarios using consistent definitions
- Check a spreadsheet or dashboard calculation
Frequently asked questions
What formula does Lost Value per Lost Deal use?
Lost Value per Lost Deal = Lost opportunity value ÷ Lost deals × 1
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.