Table 5From “Forecast accuracy can hide offsetting errors”
The row-level forecast-error audit
Table 5The row-level forecast-error audit
| Audit field | Required question | Failure if omitted |
|---|---|---|
| Forecast object | What exactly was forecast: units, revenue, opportunities, capacity, or something else? | Unlike rows are silently combined |
| Baseline and final forecast | Was an intervention applied, and what was the untouched value? | FVA and override effects cannot be separated |
| Actual outcome | What event closed the forecast window? | Error is calculated against a moving target |
| Signed error | Which direction convention is in force? | Bias changes sign or becomes uninterpretable |
| Absolute or squared error | How large was the miss regardless of direction? | Cancellation is mistaken for accuracy |
| Horizon | How far ahead was the forecast issued? | Short and long forecasts are treated as identical |
| Denominator | What base creates the percentage comparison? | Ratios change without a visible measurement change |
| Segment and tail flag | Which rows create persistent or severe errors? | Aggregate averages erase the operational problem |
| Decision cost | What does an over- or underforecast make the organization do? | Metric improvement is mistaken for decision value |
Swipe or scroll horizontally if the table is wider than your screen.
Source: Table from this essay. Sources and interpretation are given in the article.

From the essay
Revenue operations & AI
Forecast accuracy can hide offsetting errors
A forecast can be unbiased on average while missing every period: keep signed error, absolute error, distribution, horizon, and decision cost separate.
Read the essayThis exhibit belongs to an essay: the numbers live here, the argument lives there.
Cite or embed
Related exhibits

Table 1Table
The forecast-error cancellation trap
Forecast accuracy can hide offsetting errors

Table 1Table
What does sales forecasting mean before accuracy is summarized?
Forecast accuracy can hide offsetting errors

Table 3Table
One word called accuracy hides several measures
Forecast accuracy can hide offsetting errors
Contact
Bring the question you're working on.
Research, a guest lecture, or a commercial question.