Skip to main content
DD-CRM-002-Q022 Medium Time series

Forecast bias in 2025

Actual = Revenue in FactLedgerRevenue for the same AccountID and month (0 if there is none). For the forecast months of 2025, by what percentage did total Commit exceed total Actual (both companies)? 2 decimals (negative if below).
Expected
One percentage, 2 decimals · KPI card
Tables
FactForecast, FactLedgerRevenue · columns
  • FactForecast
  • FactLedgerRevenue
  • Commit
  • ForecastMonth
  • AccountID
  • Revenue
  • PeriodKey

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us