Register

NaN

dsoomar002
Certified Master Anaplanner

NaN

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.

1 REPLY 1
jasonblinn
Master Anaplanner/Community Boss

Re: NaN

@dsoomar002 

 

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