I am doing SQL Server query calculations and the division always gives me zero.
SUM(sl.LINES_ORDERED)
, SUM(sl.LINES_CONFIRMED)
, SUM(sl.LINES_CONFIRMED) / SUM(sl.LINES_ORDERED) AS 'Percent'
The sample dataset returned is:
In this example, the third row should have a division value of 1.02, but it's shown as zero. Why is that?