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