Help with Null

[Sa743liz-]

Why the first formula is not working and the second one yes? They suppose to be same. 

[Felipe_Ribeir0 · Accepted solution]

Hi @Sa743liz- 

Change the data type of all columns involved in this formula to double with the select tool, right before of the formula tool and try to run it again

[Qiu]

@Sa743liz- 
Agree with @Felipe_Ribeir0 , it seems most likely that column [Fixed Charge Coverage Ration] is not a Numeric Data type. Please change it to Double with a Select Tool and give a try.

[grazitti_sapna]

@Sa743liz- , you need to change the data type for the column [Fixed Charge Coverage Ration], either you can use Select tool and change its data type or you can directly use ToNumber([Fixed Charge Coverage Ration]) in the formula you have applied.

[Sa743liz-]

Thank you so much, that fixed the problem.