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