Case in sql

deeparavi · #1 (**permalink**) 01-13-11, 05:01

I have a case statement in my SQL query like this

Sum(case when amount_d_c= 'd' then -amount else Amount end)As total_amount

My resullts contain numbers with + and - signs.
I want my results to appear again as d if -ve and c if +ve.

Can I add another case statement? If yes how
Please help

dbzTHEdinosaur · #2 (**permalink**) 01-13-11, 08:21

you want the results of your sum to be either D or C?
then put your case outside of the SUM.

dav1mo · #3 (**permalink**) 01-13-11, 22:14

do you mean?

Code:

case when Sum(case when amount_d_c= 'd' 
                                   then -amount
                              else Amount
                       end)< 0 
            then 'd'
        else 'c' 
end As total_amount

Dave

Internet Services

Web Development

Digital Marketing

Consumer Tech