|
Could anybody tell me why (SUM(TSCOMD)/SUM(TSSLS$)) always returns 0 in the
following select statement:
V5R2,
The two SUM() fields never equal 0 yet the result of the division comes back as
0?????????
SELECT
TSSLS#,
IDGRP,
SUM(TSSLS$),
SUM(TSCOMD),
(SUM(TSCOMD)/SUM(TSSLS$))
FROM LIB.SLPTS
JOIN LIB.INDESCRP ON IDS# = TSPRD and IDSF = 'A'
WHERE IDGRP = 957 AND TSSTS <> 'D'
GROUP BY IDGRP, TSSLS#
ORDER BY IDGRP, TSSLS#
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.