Subtraction float numbers

[Anonymous]

Hi!

Sorry if this question was recently discussed, I can't find an answer here.

When I make subtraction of numbers 94.6-94 or 94.4-94 at sheet objects I got unexpected result like 0,59999999999999 or 0,40000000000001.

Seems that this trouble because of known problem with floating numbers.

But how it can be solved in QlikView? Only using Round() or set Fixed number at field properties?

[Anil_Babu_Samineni]

Qlikview not able to understand the exponential. So that it may shows till there limit(15 digits). So, you have to work on the data points by using Num(). And use Ceil() / Round() / Floor()

[tresesco]

For detailed understanding, you may refer: Rounding Errors