Substracting Values

Hi All,

I just want to calculate this formula in my report.

my code is as follows.






Code Block
WITH CDsTotalOutstandingCTE AS
(
SELECT type = 'CDs Total Out Standing'
, TotalOutStandingValue = (select sum(Amount)
from CertificateDeposit
where State = 'Current')

),
LoansTotalOutstandingCTE AS
(
SELECT type = 'Loans Total Out Standing'
, TotalOutStandingValue = (select sum(Amount)
from Loan
where State = 'Current')
),

combinedCTE AS
(
SELECT * FROM CDsTotalOutstandingCTE
UNION ALL
SELECT * FROM LoansTotalOutstandingCTE

)
SELECT *

FROM combinedCTE






Now I want to add another row to my table which would give Net Total Outstanding value.

It is calculated as follows.

Net outstanding value = TotalOutstandingValue(Calculated from CD table) - TotalOutstandingValue(Calculated from Loan table)


Can any one help me please?