Decimal divide in report calculation

[Steve_Bache]

Help please , I have a calculated field in a report that works fine (most of the time) :-

=(100/(Sum([Sum Of Count])-Sum([Expr1])))*Sum([Completed])

but I get a decimal divide (obviously) if dividing 100 by zero. What is the correct syntax for testing and bypassing this ?

Suggestions ( helpful ones !) welcome.

Cheers

Steve

 

[KenHigg]

Unless you can test a single expression, the following should work

= if((Sum([Sum Of Count])-Sum([Expr1])))*Sum([Completed]) = 0, 0, 100/(Sum([Sum Of Count])-Sum([Expr1])))*Sum([Completed]))

This was just off the top of my head, there may be a better way to do this...

 

[Steve_Bache]

Ken ,

Thanks for the response - will give it a try !

Cheers

Steve