Division By Zero 1

[nt95]

I have created the following field to calculate a Net Income %age by Customer:


iif(Sum ({DLOG.DLREV$},{CUST.CNAME})<=0,1,(Sum ({@Net Income},{CUST.CNAME})/Sum ({DLOG.DLREV$},{CUST.CNAME})*100))

I can scroll through the report until I get a Customer with a negative Net Income %age. Then I get a "Division by zero" error.

Any thoughts?

 

[Woodyuk]

I have had this in reports before, and I think its the same as what ive doen to fix it try this.

Hope it works

if Sum ({@Net Income},{CUST.CNAME})<>0 then
if Sum ({DLOG.DLREV$},{CUST.CNAME})<>0 then
if(Sum ({DLOG.DLREV$},{CUST.CNAME})<=0,1,(Sum ({@Net Income},{CUST.CNAME})/Sum ({DLOG.DLREV$},{CUST.CNAME})*100)) else 0

 

[nt95]

Problem solved.

Thanks so much.