Skip to main content
DD-CRM-002-Q038 Hard

Commission without the phantom deals

Recalculate the commission for the plan periods whose PeriodStart is in calendar 2025, paying the NewBusinessBonus only on deals whose account has Revenue in FactLedgerRevenue. What is the total commission, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactCommissionPlan, FactOpportunity, FactLedgerRevenue · columns
  • FactCommissionPlan
  • FactOpportunity
  • FactLedgerRevenue
  • TotalCommission
  • NewBusinessBonus
  • PeriodStart
  • OwnerID
  • 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