NaN

DaanishSoomar

Hello,

 

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.

jasonblinn

@DaanishSoomar 

 

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

ryan_kohn

@alexpavel has authored a nice post on this topic containing various options for dealing with a NaN or Infinity result: https://community.anaplan.com/t5/How-To/How-To-Convert-Infinity-Infinity-NaN-to-Zero-Value/ta-p/117120