Forum Discussion

Qrew Trainee

6 months ago

Division Formula error

What is the best way to handle a division formula that is dividing by zero and returns an error? I would like the error to return a Zero.

Qrew Legend

6 months ago

Np,

var text Numerator = insert formula here;

var text Denominator = insert formula here;

IF($Denominator=0, 0, $Numerator / $Denominator)