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.