The most accurate forecaster
Actual = Revenue in FactLedgerRevenue for the same AccountID and month (0 if there is none). Take the Mizan Manufacturing owners who submitted a forecast for every month of 2025. For each owner and month, error = |their total Commit - their total Actual| / their total Actual (skip a month with no Actual). Which OwnerID has the lowest average monthly error?
- Expected
- One OwnerID · KPI card
- Tables
-
FactForecast, FactLedgerRevenue · columns