Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

potekhin
New Contributor

Subtraction float numbers

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?

Tags (2)
2 Replies

Re: Subtraction float numbers

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()

MVP
MVP

Re: Subtraction float numbers

For detailed understanding, you may refer: Rounding Errors