asked
Computed column in SELECT CASE t-sql
I've got a computed column: BilledAmount = CASE WHEN CoverageItem in ('MED','RNB', 'LAB') THEN ISNULL(SUM(ISNULL(hb.BilledAmt,0)),0) END FROM HospitalBill hb with(nolock) Basically, what it does is sum up the amount billed with a coverage item of for example MED from the HospitalBill table...What I wan't to do is to add another case which if the CoverageItem = 'BEN'... then the BilledAmount would be the sum of the BilledAmounts with the CoverageItem of 'LAB' and 'BEN'.. is that possible..
Sure, you can do that. Just add another WHEN and THEN clause before the END statement and you should be fine.
15 People are following this question.
