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
