topic Re: Round the resut to two decimal in App Development

Round the resut to two decimal

euriss_sow — Mon, 20 Dec 2021 21:02:46 GMT

Hey Guys,

I am facing an issue on trying to fix my client data.

Here is the formula:

round(colA * colB / 100,0.01)

So I am expected to get my result in two decimals.

But this is what I get from Round function.

anything ends with 9, round-up work unexpected.

Re: Round the resut to two decimal

joaopaulo_delco — Sun, 21 Mar 2021 21:19:46 GMT

Hi @euriss_sow !

Try this

num(ori_result,'#,##0.00') as result_new,

Re: Round the resut to two decimal

marcus_sommer — Mon, 22 Mar 2021 17:18:54 GMT

Qlik used a binary number-system. This means that many decimal-numbers haven't an exact binary equivalent. In your case the number 0.595 isn't available else the binary of it is a bit smaller and probably like this: 0.594970703 which then leads to your seen rounding. It's not really wrong.

- Marcus

Re: Round the resut to two decimal

Arthur_Fong — Tue, 23 Mar 2021 07:28:42 GMT

One workaround is to perform rounding before division.

The expression should look like this :

round(colA*colB)/100

Thanks and regards,
Arthur Fong

Re: Round the resut to two decimal

euriss_sow — Tue, 23 Mar 2021 07:31:33 GMT

Hi Marcus,

The figure is exact 0.595.

Re: Round the resut to two decimal

euriss_sow — Tue, 23 Mar 2021 07:33:16 GMT

HI @joaopaulo_delco

this I have tried before, I can get as two decimals but if I reuse this column for calculation. it will still count as 0.595.

Re: Round the resut to two decimal

marcus_sommer — Tue, 23 Mar 2021 09:17:12 GMT

Not really, see: Rounding Errors - Qlik Community - 1468808

- Marcus

Re: Round the resut to two decimal

MayilVahanan — Tue, 23 Mar 2021 09:42:01 GMT

HI @euriss_sow

Might be, this link helps you.

https://community.qlik.com/t5/QlikView-App-Dev/Round-function-giving-sometimes-incorrect-results/td-p/695933

ex: Round(0.595+ 0.0000000001,0.01)

Re: Round the resut to two decimal

euriss_sow — Wed, 24 Mar 2021 03:51:28 GMT

We have tested with this formula

round(11.9*(5/100),0.01) = 0.60

round(11.9*5/100,0.01) = 0.59

what is the difference here?