×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
oK, below is my statement and output in question...
SELECT ROUND(AVG(A1),0) * .20, ROUND(AVG(A2),0) * .30,
AVG(A3), ROUND(AVG(A4),0) * .10
From (
SELECT MPMRS, mpdate,
AVG(MPI5TMS) AS A1, AVG(MP#ATTS) AS A2,
AVG(MP#INSTS) AS A3, AVG(MP#SCPS) AS A4
FROM MRSSTATSPF
WHERE MPDATE >= '2008-04-07' AND MPDATE < '2008-04-12'
AND MPDETL = 'D' AND MPMRS = 'BILLIEO' AND MPPGRP = 'LN
AND MPCLVL = '4'
AND MPRVIA = 'E' AND MPPROC = 'ME'
AND (NOT ( MPCLVL = 4 AND MPRVIA = ' '))
AND (NOT ( MPCLVL = 5 AND MPRVIA = ' '))
GROUP BY MPMRS, mpdate) AS AVGLIST
output...
.8
.9
2.8
.4
However, when I simply change...
AVG(A3) to ROUND(AVG(A3),0) * .40
the third ouput becomes +++++++++++++++
Why is this?
Thanks,
Jay Vaughn
Senior I5 Programmer/Analyst
RateWatch
(P) 251.209.8968
www.rate-watch.com
midrange.com
