avoid div by zero

  • Thread starter Thread starter sapta
  • Start date Start date
S

sapta

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

thanks in advance

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

=if(divisor = 0, 0, dividend/divisor)
 
I tried many function before including if,iif,case
but still not found the corrects ones !
thanks
 
Back
Top