Qlikview weird behaviour

[#1]

Hi, in my case i'm connected to a database and download some data, one of the field is an simple numeric value. When qlikview just show me the value of this field it says '100',

len(trim(field)) = 3, it's ok until now :
len(trim(floor(field)))=2

and bitcount(field)=4 - it should return 3

moreover if(field=100, 'TRUE', 'FALSE') return false ...

How is this possible ? Problem with encoding ?

[#2]

This is bit strange. From which database you pulling the data? Secondly are you saving this into a qvd and then applying the QV functions or in extraction load.

[#3]

Well, i figured out that this wasn't 100 but smth like 99.99999999 ...