How to handle DIV/0 errors in Web Intelligence

A short and simple post about handling DIV/0 errors.

To handle DIV/0 errors, use the If() and IsError() functions.

IsError() will return a true or false value depending on the item being evaluated. Wrap this with an If() statement and you can evaluate the formula as normal is if it is ok, or return a message to the user if there is an error:

=If(IsError(15/0);”Error in formula”;15/0)

Advertisements
%d bloggers like this: