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

Missing numbers at the trade counter, 2025

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. How many numbers are missing from BR-C's 2025 sequence?
Expected
One whole number · 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