RE: SQL SUM(fieldname) - can I use CASE??

Are you wanting a sum by item-group?

CASE statement should do it for you.

SELECT item-group,
SUM(CASE item-group WHEN 'A' THEN fieldname
WHEN 'B' THEN fieldname * -1
END)
FROM filename
GROUP BY item-group

Any groups other than "A" or "B"? You could add an ELSE clause to the CASE
statement.

Have fun!


-----Original Message-----

Can I sum a fieldname using the CASE stmt as follows:

when the item-group = 'A', sum as is;
when the item-group = 'B', multiply by -1 and then sum?


How is this best accomplished?

Must I have two select stmts, one for the 'A' group and another for the 'B'
group?

Or can I somehow use the CASE stmt to sum each case differently?

Or a better way?

Thanks