Division by Zero error 2

[cyreports]

I am gettiing a Division by Zero error on this and not sure how to fix, I thought I had, but guess not.

if SUM({Data.InsPayment}) + SUM({Data.PatPayment}) = 0 then 0
else 
(SUM({Data.InsPayment}, {@Group3}) + SUM({Data.PatPayment}, {@Group3})) % (SUM({Data.InsPayment}, {@Group2}) + SUM({Data.PatPayment}, {@Group2}))

 

[lbass]

if (SUM({Data.InsPayment}, {@Group2}) + SUM({Data.PatPayment}, {@Group2})) = 0 then
0 else
(SUM({Data.InsPayment}, {@Group3}) + SUM({Data.PatPayment}, {@Group3})) % (SUM({Data.InsPayment}, {@Group2}) + SUM({Data.PatPayment}, {@Group2}))

You have to test whether the denominator is 0.

-LB

 

[kray4660]

Your formula is not checking the sums at the group level (i.e., if SUM({Data.InsPayment}, {@Group3}) + SUM({Data.PatPayment}, {Group2}) = 0 then 0).

 

[cyreports]

Thank you so much!

 

[kray4660]

Cyreports, I just just noticing the similarity of your user name and the fields you are checking on. Any chance this is a report for Centricity Physician Office Practice Management?