
Not applicable
2014-02-09
05:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Round function with wrong output
Hello!
When i use the round function to complete from 3 to 2 decimal places; it give in a wrong output when the third decimal is a 5. For example at 1.235, I get the result 1.23 instead of 1.24.
I tried to think of an own creative solution, for example: first plus 0.001 and then use the round function. This only works for positive numbers, but not for negative numbers.
As a new user of Qlikview I read first several entries about this problem, but no solution is given. Is there a script that will solve this problem?
Regards, Elmar
944 Views
1 Reply


MVP
2014-02-09
05:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Have you already discovered Henric's blog post about rounding floating point values to sub-integer values?
http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors
641 Views
