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

I think something like this will work

CASE WHEN item-group = 'A' THEN sum(YourField) when item-group = 'B'
THEN sum(-1 * YourField) ELSE 0 END AS MySum,

Scott

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Friday, November 30, 2012 3:42 PM
To: 'Midrange Systems Technical Discussion'
Subject: SQL SUM(fieldname) - can I use CASE??

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




______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs
Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.