Yes, you are right:SELECT SUM( CASE WHEN merch_purch_fees < 0 THEN [Merch_Purch_Fees] WHEN merch_purch_fees > = 0 THEN [Merch_Purch_Fees] + [Per_Tran_Fees] END ) AS MSCTESTFROM [FDMS].[dbo].[Fact_Omnipay_Profitability]WHERE FDMSAccountNo = '878031202889'GROUP BY merch_purch_fees
Also, if there is a possibility that [Per_Tran_Fees] would be null (or merch_purch_fees would be null), you should account for that, for example like this:WHEN COALESCE(merch_purch_fees,0) > = 0 THEN COALESCE([Merch_Purch_Fees],0) + COALESCE([Per_Tran_Fees],0)