Skip to main content
DD-CRM-002-Q037 Hard Time series

Months the forecast ran hot in 2025

Actual = Revenue in FactLedgerRevenue for the same AccountID and month (0 if there is none). For each forecast month of 2025, compare total Commit with total Actual (both companies). In how many months did Commit exceed Actual by more than 5%?
Expected
One whole number · Line chart of Commit against Actual by month
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