I am working on an average days to pay report. I am pulling all payments grouped by invoice and summing them to compare to invoice totals, then taking the max of the payment dates. Then I deduct the invoice date from the max payment date, returning a "days to pay" for each invoice but I can't seem to figure out the final step, average the days to pay. Not an option in the summary or running totals wizards. I think it is "possible" as a manual summary but need a little help with the formulas and where to place them in the report.
Group one customer_no and group two invoice_no
In advance thanks for the help!!
Group one customer_no and group two invoice_no
In advance thanks for the help!!