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?

[amitrathi239]

instead of blank use 0 in the if else condition.

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