avoid div by zero
 

Dear All,
how can we avoid division by Zero in calculated field
using MS QUERY ?

thanks in advance

sapta

avoid div by zero
 

can't say specifically, but usually, when dealing with formulas you can use
an if statement

=if(divisor = 0, 0, dividend/divisor)

--
Regards,
Tom Ogilvy


"sapta" wrote in message
...
Dear All,
how can we avoid division by Zero in calculated field
using MS QUERY ?

thanks in advance

sapta

avoid div by zero
 

I tried many function before including if,iif,case
but still not found the corrects ones !
thanks

-----Original Message-----
can't say specifically, but usually, when dealing with
formulas you can use
an if statement

=if(divisor = 0, 0, dividend/divisor)

--
Regards,
Tom Ogilvy


"sapta" wrote in message
...
Dear All,
how can we avoid division by Zero in calculated field
using MS QUERY ?

thanks in advance

sapta



.