I would like to apologize in advance if I am not in the proper
newsgroup.
At any rate--on an Oracle 7.3 database, I tried to use the following
query:
SELECT PD.CustomerID,
Avg(PD.PayDays) AS AvgPayDays
FROM (
SELECT R.CUSTOMER_ID AS CustomerID,
R.LAST_PAID_DATE - R.INVOICE_DATE AS PayDays
FROM RECEIVABLE R
WHERE R.LAST_PAID_DATE > R.INVOICE_DATE AND
R.TYPE = 'I' AND
R.STATUS = 'A'
UNION ALL SELECT R.CUSTOMER_ID AS CustomerID,
0 AS PayDays
FROM RECEIVABLE R
WHERE R.LAST_PAID_DATE <= R.INVOICE_DATE AND
R.TYPE = 'I' AND
R.STATUS = 'A'
) PD
GROUP BY PD.CustomerID
Obviously, I am trying average the difference of an invoice-date and a
pay-date but I want prepaid invoices to be averaged as a zero.
Obviously, I am stupid. I have no idea how to do this any other way;
please enlighten me.
Received on Fri Jul 13 2001 - 21:38:31 CEST