Skip to main content
DD-AUD-002-Q008 Easy

The value that slipped the year

What is the total NetAmount of the invoices whose ShipDate falls in an earlier calendar year than their InvoiceDate?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactInvoiceRegister, FactInvoiceRegisterLatest · columns
  • FactInvoiceRegister
  • FactInvoiceRegisterLatest
  • ShipDate
  • InvoiceDate
  • NetAmount

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