Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Re: Function Round Question.

Hi, Jonathan:

How do I get provided to access this link --

num() rounds differently to round() for half-step values

http://community.qlik.com/message/423596#423596

or

have any workaround solution ?

Many thanks.

   Kent Liao

Employee
Employee

Re: Function Round Question.

This provides better context on the inconsistencies.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/17/rounding-errors

The suggestion is to avoid rounding to sub-integer fractions.  Like rounding to .5 or .6 etc...

In your case, instead of rounding to a sub-integer fraction, multiply by 10 and round to an integer, than divide by 10 as follows:

= ROUND(26364461.45 * 10) / 10

Highlighted
Partner
Partner

Re: Function Round Question.

HI, Manojqlik & Jonathan:

Thanks a lot, I'll try it.

by the way, is this Bug possible to fix, when?

Best Regards...

   Kent Liao

Not applicable

Re: Function Round Question.

Hi kent,

that we need to ask  qliktech,  but i am not sure how much time it takes,

pls make this thread close