Skip to Content

Div/0 error in Web Intelligence and how to handle it

Div/0 error is one of the most common errors in Web Intelligence reports

 

This error is related to the measure objects, so is visible only in measure columns or where calculations are used i.e. divisions

 

This error is thrown when one of the measure values is divided by another measure value where the value of Denominator is zero.  Reason being simple as it is not possible to divide any numeric value by zero Web Intelligence throws the error when you force it to calculate it.

 

How do we resolve this?

 

If you are aware that your DB measure column has zero values, you can avoid this error at the report level by checking for zeros in Denominator before division calculation, as shown below

 

=IF (Denominator = 0) Then 0 Else (Numerator / Denominator)

 

An alternative more generic method but not directly related to Div/0 can also be used, i.e to check nulls and error to avoid any error

 

= IF IsNull(Denominator) Then 0 Else (Numerator / Denominator)

 

OR to check any error

 

= IF IsError (Numerator/Denominator) Then 0 Else (Numerator / Denominator)

 

IsNull and IsError are Boolean functions and returns 1 or 0 depending if the value is true or false respectively

1 Comment
You must be Logged on to comment or reply to a post.
  • Bonjour,

    Techniquement parlant votre proposition (=IF (Denominator = 0) Then 0 Else (Numerator / Denominator)) donne un résultat correcte. Mais, le fait de retourner zéro (0) si le dénominateur est nul peut induire à l’erreur sur l’interprétation du résultat final. Pour être plus précis il faut mettre =IF Denominator <> 0 Then (Numerator / Denominator).