Use Virtual Key Figures for Complex Weighted Average KPIs
Within the scope of Accounts Receivable reporting we have to calculate Days Overdue KPI, a number of days each invoice has not been paid (due date – key date) and average it over customers using outstanding invoice amounts as a weighted average parameter.
