Spreadsheet: 816323d1675513287-complex-unique-count-formula-count-4-
Sheet: TranxData

 |  |  |  |  |  | Split payments have the same refs.
 |  | Month/Year | MissedPaymentDate | Client | TransactionType | OurReference | Quantity | Amount | PaymtType | [NAME] | ProductCode | PaymentDate | ClientAccount | DistAgency | Currency | UnpaidQuantity | UnpaidAmount | MissedPaymtReason | MissedPaymtCausedby | ActualPaymtDate | PaymtEffect | Zone
 |  |  | 2022-03-01 00:00:00 | Cubetronics | COP | WEF567 | 700 | 2400 | DirectDebit | 5-day | YU00PP | 2022-03-05 00:00:00 | CAM123 | AG_567 | EUR | 700 | 2400 | Expired credit Line | Customer | 2022-03-05 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-09 00:00:00 | Haxelnut ltd | SOC | WEF980 | 1000 | 3200 | CreditCard | 5-day | [NAME] | 2022-03-14 00:00:00 | CAM67 | AG_01 | USD | 1000 | 3200 | Card expired | Customer | 2022-03-14 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-10 00:00:00 | Cubetronics | COP | WEF0201 | 400 | 8000 | Cash | 5-day | DE0001 | 2022-03-15 00:00:00 | CAM123 | AG_13789 | EUR | 200 | 4000 | credit issue | Customer | 2022-03-20 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-22 00:00:00 | Cubetronics | COP | WEF0201 | 400 | 8000 | Cash | 10-day | DE0001 | 2022-03-20 00:00:00 | CAM123 | AG_13789 | EUR | 200 | 4000 | credit issue | Customer | 2022-03-20 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-01 00:00:00 | Foxtrotltd | SOC | DEF246 | 2500 | 30000 | CreditCard | 5-day | JP5600 | 2022-03-05 00:00:00 | CAMN459 | AG_389 | GBP | 2000 | 24000 | Filing error | Customer | 2022-03-30 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-01 00:00:00 | Foxtrotltd | SOC | DEF246 | 2500 | 30000 | CreditCard | 10-day | JP5600 | 2022-03-10 00:00:00 | CAMN459 | AG_389 | GBP | 1500 | 20000 | Filing error | Customer | 2022-03-30 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-01 00:00:00 | Foxtrotltd | SOC | DEF246 | 2500 | 30000 | CreditCard | 15-day | JP5600 | 2022-03-15 00:00:00 | CAMN459 | AG_389 | GBP | 1000 | 18000 | Filing error | Customer | 2022-03-30 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-01 00:00:00 | Foxtrotltd | SOC | DEF246 | 2500 | 30000 | CreditCard | 20-day | JP5600 | 2022-03-20 00:00:00 | CAMN459 | AG_389 | GBP | 500 | 6000 | Filing error | Customer | 2022-03-30 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-01 00:00:00 | Foxtrotltd | SOC | DEF246 | 2500 | 30000 | CreditCard | 30-day | JP5600 | 2022-03-30 00:00:00 | CAMN459 | AG_389 | GBP | 500 | 6000 | Filing error | Customer | 2022-03-30 00:00:00 | Debit | [NAME] |  |  | Split payment so only one row should be counted
 |  |  | 2022-03-12 00:00:00 | Cubetronics | COP | WEF8873 | 900 | 9000 | DirectDebit | 10-day | HU2001 | 2022-03-22 00:00:00 | CAM123 | AG_13789 | GBP | 900 | 9000 | Expired credit Line | Customer | 2022-03-22 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-07 00:00:00 | Haxelnut ltd | SOC | WEFY589 | 2300 | 69000 | CreditCard | 20-day | LP780001 | 2022-03-27 00:00:00 | CAM67 | AG_01 | USD | 2300 | 69000 | Card expired | Customer | 2022-03-27 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-03 00:00:00 | Decagon Ltd | COP | WEFU590 | 581 | 6300 | DirectDebit | 5-day | LP256 | 2022-03-08 00:00:00 | [NAME] | AG_13789 | USD | 581 | 6300 | Expired credit Line | Customer | 2022-03-08 00:00:00 | Debit | SOUTH2
 |  |  | 2022-03-04 00:00:00 | Decagon Ltd | COP | WEFU591 | 1138 | 56400 | DirectDebit | 5-day | OP687 | 2022-03-09 00:00:00 | [NAME] | AG_1987 | USD | 1138 | 56400 | Expired credit Line | Customer | 2022-03-09 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-05 00:00:00 | Decagon Ltd | COP | WEFU592 | 2857 | 119100 | DirectDebit | 5-day | LP257 | 2022-03-10 00:00:00 | [NAME] | AG_1987 | USD | 2857 | 119100 | Expired credit Line | Customer | 2022-03-10 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-06 00:00:00 | Decagon Ltd | COP | WEFX593 | 6000 | 12000 | Cash | 5-day | DE0001 | 2022-03-11 00:00:00 | [NAME] | AG_1987 | GBP | 3000 | 6000 | credit issue | Customer | 2022-03-16 00:00:00 | Debit | [NAME]
 |  |  | 2022-03-06 00:00:00 | Decagon Ltd | COP | WEFX593 | 6000 | 12000 | Cash | 10-day | DE0001 | 2022-03-16 00:00:00 | [NAME] | AG_1987 | GBP | 3000 | 6000 | credit issue | Customer | 2022-03-16 00:00:00 | Debit | [NAME]