NaN

DaanishSoomar
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 ACCEPTED SOLUTION

Accepted Solutions
jasonblinn
Master Anaplanner/Community Boss

Re: NaN

@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

View solution in original post

1 REPLY 1
jasonblinn
Master Anaplanner/Community Boss

Re: NaN

@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