Forum Discussion
- MarkShnier__YouQrew Legend
Np,
var text Numerator = insert formula here;
var text Denominator = insert formula here;
IF($Denominator=0, 0, $Numerator / $Denominator)
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.
Np,
var text Numerator = insert formula here;
var text Denominator = insert formula here;
IF($Denominator=0, 0, $Numerator / $Denominator)