We have a debtor table with a field average days to pay. that is, the average number of days the debtor takes to pay an invoice.
If I want to know whether the average days to pay overall is increasing or decreasing how would I calculate that?
At first I thought it was simply sum(AverageDaysToPay) / NumberOfDebtors but this seems wrong.
Thanks in advance.