SQL Calculation

I have the following two calculations below. I need to combine these into one.

A. SELECT ISNULL(CAST((@IndemReserve - t.Claims_Retention) * t.Treaty_Claims_PCT AS NUMERIC(12, 2)), 0.00)

B. SELECT ISNULL(CAST((@ResultOfA / nullif(@IndemReserve, 0)) * @ExpReserve AS NUMERIC(12, 2)), 0.00)

Thank you for your help.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
And what exactly is the problem?
You could just put the expression A into the place where you indicated @resultofA ...
mburk1968Author Commented:
I do ot know how that looks formatted properly. I have tried all afternoon and keep getting formatting errors.
mburk1968Author Commented:
I understand what you meant now. Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.