Requirement:
Summarize PIFAmt column divide by Summarize Factors column by StateName column and diplay prior & current year data as a table column by auto and property business values.
Table Structure:
Table Data:
You could avoid the following errors when you execute the enclosed SQL select statement and display the result as I explained in my requirement.
Errors:
Server: Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Server: Msg 130, Level 15, State 1, Line 3
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
Results:
