Help with Summing a field defined in a case

[trulyblessed]

I have the following line and I would like to sum on "scripts" but it keeps telling me that "scripts" is not a valid column name. Any suggestions?

Scripts = case PaymentTypeId when '3' then p.tpm when '2' then p.tpm when '1' then p.cash else 1 end

 

[sunila7]

Hi,

Try this...........


Select Sum(case PaymentTypeId when '3' then p.tpm when '2' then p.tpm when '1' then p.cash else 1 end) from TBL

Hope this helps.......

Sunil

 

[trulyblessed]

Thank you so much. That did it!