Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to clear off Infinity and NaN value?

Hi. I wanted to create another column based on this column.   I understand that NaN & infinity is because my calculations are when 0 divided by value, if I'm not mistaken, right? So what ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak if my formula looks like this, how should I change it? 

LOSS wrt MED (TRIP IN) = ABS(SUMX(ODBS_FTO_BHA,(ODBS_FTO_BHA[Minus MED TRIP IN]/24)*(ODBS_FTO_BHA[RIG_COST]*1000)))
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , divide by 24, can not cause Divide by 0 error. +0 can handle blank here 

LOSS wrt MED (TRIP IN) = ABS(SUMX(ODBS_FTO_BHA,(ODBS_FTO_BHA[Minus MED TRIP IN]/24.0)*(ODBS_FTO_BHA[RIG_COST]*1000)))+0

 

or try

LOSS wrt MED (TRIP IN) = ABS(SUMX(ODBS_FTO_BHA,Divide(ODBS_FTO_BHA[Minus MED TRIP IN],24.0,0)*(ODBS_FTO_BHA[RIG_COST]*1000)))+0