I believe I am running into an issue where some formulas are using the Divide logic and running into NaN when dividing by 0. 


Does anyone have any reccommendations when converting NaN to 0? The formulas I have logic which says: If Numerator= 0 then 0 else if Denominator =0 then 0 else numerator/denominator. 


However, what should I do if my Denominator = NaN? The denominator is being calculated by some other math and is returning NaN.

Best Answer

  • jasonblinn
    Answer ✓



    Not sure if this is the best solution, but I have used something like this in the past: 


    IF Denominator >= 0 OR Denominator <= 0 THEN Numerator / Denominator ELSE 0