avoid div by zero

[sapta]

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

thanks in advance

sapta

 

[Tom Ogilvy]

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

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

 

[sapta]

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