Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Trainee
4 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.

  • Np,

    var text Numerator = insert formula here;

    var text Denominator = insert formula here;

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