Skip to main content
DD-AUD-002-Q018 Medium

Where the numbers go missing

Invoice numbers restart each year per branch (SeqYear, SeqNo). Within one BranchCode and SeqYear, the missing numbers are (highest SeqNo - lowest SeqNo + 1) minus the count of invoices present. Which BranchCode has the most missing numbers in its 2025 sequence?
Expected
One BranchCode · KPI card
Tables
FactInvoiceRegister, FactInvoiceRegisterLatest · columns
  • FactInvoiceRegister
  • FactInvoiceRegisterLatest
  • BranchCode
  • SeqYear
  • SeqNo

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