The same quarter, two verdicts
| Team | Forecast | Actual | Absolute error | Percentage error |
|---|---|---|---|---|
| Enterprise | $6.0M | $5.4M | $600K | 11.1% |
| SMB | $400K | $250K | $150K | 60.0% |
Both readings are correct. The $600K enterprise gap is the number that changes a hiring plan. The 60% SMB gap is the number that says the SMB forecasting process does not work. Reporting only one of them means one of those two problems goes unaddressed.
When absolute error is the right lens
Use absolute error whenever the forecast is funding something. Headcount and marketing spend both consume dollars, and a plan does not care what percentage of a segment a shortfall represents.
Absolute error is also the honest lens on concentration. A quarter carried by a handful of large deals will show a small percentage error while a single slipped deal moves the dollar gap more than an entire segment. ORM's finding that only 20% of the pipeline carrying in-quarter close dates on day one actually closes in that quarter is a dollar problem before it is a percentage one.
When percentage error is the right lens
Use percentage error whenever you are comparing forecasters or forecast processes rather than outcomes. A rep on a $400K territory and a rep on a $4M territory should be held to the same standard, and only the percentage form does that.
Percentage error is also what makes a target portable. ORM sees manual forecasts on new and expansion business land near 90% accuracy and targets 95%, and those numbers mean the same thing to a $10M company and a $200M one. A dollar target would not survive the translation.
Reporting both
The workable pattern is two columns in the same review. Lead with dollars for the executive decision and follow with percentage for the process diagnosis. Read the direction of each error separately so a lean does not hide inside an average. That layout shows what the miss cost and whether the forecasting method that produced it is sound. Build it into your forecast accuracy reporting and the sales forecasting cadence that surrounds it.
Frequently Asked Questions
What is the difference between absolute error and percentage error?
Absolute error is the raw gap between forecast and actual in dollars. Percentage error divides that gap by the actual. A $600K miss on a $5.4M enterprise number is 11%, while a $150K miss on a $250K SMB number is 60%, so the two measures rank the same pair of forecasts in opposite orders.
Which one should go in a board deck?
Absolute error, because the board is deciding what to commit and commitments are made in dollars. Include percentage error underneath it so leadership can see whether a large dollar gap came from a large business or a badly forecast one.
When does percentage error break?
Percentage error divides by the actual, so it is undefined when the actual is zero and it explodes when the actual is small. A new segment that closes $40K against a $150K forecast posts a 275% error that says almost nothing about forecasting quality.
Can you use both measures at once?
Yes, and most mature forecasting reviews do. Report absolute error for the decisions being funded and percentage error for grading the people and processes producing the calls. They answer different questions and neither substitutes for the other.
Put these metrics to work
ORM builds custom revenue forecast models that turn concepts like absolute error vs percentage error into prescriptive action for your team.
Schedule a Demo