Calculated measures and KPIs
This table shows the measures that are calculated in the cube:
| Measure | Description |
|---|---|
| Avg Days – Due & Pmt | The number of days between the due date and the final payment date divided by the number of invoices |
| Avg Days – Invc & Due | The number of days between the invoice date and the due date divided by the number of invoices |
| Avg Days – Invc & Pmt | The number of days between the invoice date and the final payment date divided by the number of invoices |
| Avg Days – Invc & Recon | The number of days between the invoice date and the internal reconciliation date divided by the number of invoices |
| Receivable Index | A way to rate a customer's payment history, computed as the weighted overdue amount divided by the weighted invoice amount by the due date |