Div/0 error returns empty for graph

[Former Member]

Hi in some cases the measurement can't be calculated due to missing data. In that case I'd like the graph to show no value. Now it shows an error, which doesn't look good to the user.

The graph is looking ok in this example, indicating 0 would be false, therefore missing values are preferable but without the yellow error icon.

I want to solve for the error, but Webi doesn't seem to allow empty values. For example I've tried IF(Iserror{ [numerator] / [denominator]); ""; [numerator] / [[denominator]).

How to solve this appropriately?

[MichaelGrackin · Accepted solution]

Try reversing your formula using the Not() function and then do not return "". This will return a Null.

=If(Not(IsError([numerator] / [denominator]));[numerator] / [[denominator])

OR try this

=If([denominator]>0;[numerator] / [[denominator])

[Former Member · Accepted solution]

Thanks, the latter is already sufficient!

[amitrathi239]

instead of blank use 0 in the if else condition.

IF(Iserror{ [numerator] / [denominator]); 0; [numerator] / [[denominator])