Sum of only Positive Values of a column and sum of negative value of a column in SQL

Sum of only Positive Values of a column and sum of negative value of a column

While creating a Reports one of my colleagues asked me that he has to display sum of only Positive values of a column in a new column and sum of only negative value of a column in a new column Although it can be done easily in SSRS Report also
but his requirement was through sql code.

So below is the Sample code with Solutions

--Creating a test table with Both Position and Negative Values

create table value
(Testvalues int)

insert into value values(1),(-2),(3),(-4),(5),(-6)

Select * from Values

If you will calculate the total of positive values it will be 9 and for negative values it is -12


SO below is the Query
select
  SUM(case when Testvalues>0 then Testvalues else 0 end)SumPositiveValue,
       SUM(case when Testvalues<0 then Testvalues else 0 end)SumNegativeValues
       from value


SumPositiveValue SumNegativeValues
9                           -12