Skip to main content
DD-PRJ-003 Mizan Group: Four Programmes, One Cut-off — Project Management & Project Accounting Get the data →
DD-PRJ-003-Q036 Hard Time series

Billed ahead of progress

On the client project MOB-CUS0061, revenue earned to a date = contract value (sum of BillingAmount) x project % complete (earned value / OriginalBudget at the month end). At 31 March 2024 (the month end after milestone M2 was invoiced), what was billed to date minus revenue earned - the over-billing - in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactMilestone, FactProgress, DimTask, DimProject · columns
  • FactMilestone
  • FactProgress
  • DimTask
  • DimProject
  • BillingAmount
  • InvoiceDate
  • PercentComplete
  • BaselineBudget
  • OriginalBudget

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

Create a free account Sign in