2 Replies Latest reply: Aug 4, 2017 5:02 AM by Tresesco B RSS

    Subtraction float numbers

    Dmitry Potekhin

      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?