what is -NaNq

tanaya.deshpande@tieto.co · Mon Mar 28, 2011 11:38 pm

I am calculating a column like this (var1/var2)* 100 its result is coming as -NaNq ...but values of var1 and var2 are coming valid

what is -NaNq how can i eliminate it

tanaya.deshpande@tieto.co · Mon Mar 28, 2011 11:38 pm

the datatype of the column is double

tanaya.deshpande@tieto.co · Tue Mar 29, 2011 12:10 am

I am also getting Inf is it because the value coiming is too large to be accepted by the datatype

priyadharsini · Post by **priyadharsini** » Tue Mar 29, 2011 1:40 am

could you paste the warning message you are getting in the log and also some sample input and output data?

tanaya.deshpande@tieto.co · Tue Mar 29, 2011 3:46 am

there are no warnings generated

synsog · Post by **synsog** » Tue Mar 29, 2011 4:23 am

NaN stands for Not a Number...check your data ..