Calculations using a Union query 1

Stewman · Mar 12, 2014

Hello,

I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this:

Kount Type
786 Duplicates
11737 Orders
38503 Calls

What I want is to do the following calculation within this sql query.

(Calls + Orders) - Duplicates

Is this possible?

Thanks,

Chris

PHV · Mar 12, 2014

One way:

SQL:

SELECT SUM(Kount*CASE WHEN Type='Duplicates' THEN  -1 ELSE 1 END) AS CalculatedAmount
FROM yourUnionQuery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

Stewman · Mar 12, 2014

Thanks PHV it worked great. Exactly what I wanted.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Calculations using a Union query 1

Stewman

MIS

PHV

MIS

Stewman

MIS

Similar threads

Part and Inventory Search

Sponsor