hrishi hrishi - 6 days ago 6
SQL Question

how to minus negative values in sum?

I am using

SUM()
function. But
SUM()
sums the negative value in the column. In a column if the value is positive then it should be added and for negative values should be substracted and not added as the
SUM()


20.00
20.00
20.00
20.00
-20.00
20.00
20.00
40.00
20.00
20.00
20.00
20.00
20.00
-20.00
-20.00
20.00


sum() should return 220 and not 440.
Is returning 440.

Answer

To subtract negative numbers rather than add them you would use SUM(ABS(col)) but just to check this is what you actually need example results below.

WITH YourTable(col) AS
(
SELECT 2 UNION ALL
SELECT -5 
)
SELECT 
       SUM(ABS(col)) AS [SUM(ABS(col))],
       SUM(col) AS [SUM(col)]
FROM YourTable

Returns

SUM(ABS(col)) SUM(col)
------------- -----------
7             -3
Comments