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 |