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

Who forecasts high

Actual = Revenue in FactLedgerRevenue for the same AccountID and month (0 if there is none). Among owners whose forecast lines for 2025 add up to an Actual of at least USD 1,000,000, which OwnerID's total Commit is furthest above total Actual, in percentage terms?
Expected
One OwnerID · KPI card
Tables
FactForecast, FactLedgerRevenue · columns
  • FactForecast
  • FactLedgerRevenue
  • OwnerID
  • Commit
  • ForecastMonth
  • AccountID
  • Revenue

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