topic Re: Strange Decimal Number in QlikView

Strange Decimal Number

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a question.

I create one text box contain this expression :

=num(5555+(98/100), '#,##0.00000000000000') the result return 5,555.97999999999960

Is it a bug from QlikView ?

The result i expect is 5,555.98000000000000

But when i change the number of the expression become =num(1111+(98/100), '#,##0.00000000000000')

The result is correct 1,111.98000000000000

Anyone has the idea ?

Thanks in advance

devarasu07 — Wed, 05 Apr 2017 10:44:43 GMT

Hi,

Try like below,

=Num((5555+(98/100)),'$#,##0.00;($#,##0.00)')

=Num((1111+(98/100)),'$#,##0.00;($#,##0.00)')

sarvesh — Wed, 05 Apr 2017 10:45:19 GMT

Could you share that data with me.

tresB — Wed, 05 Apr 2017 10:45:43 GMT

A good read would be: Rounding Errors

devarasu07 — Wed, 05 Apr 2017 10:50:10 GMT

Hi,

ahaahaaha — Wed, 05 Apr 2017 10:53:02 GMT

Hi Chou,

Like all right you (look attached file).

You need to analyze the data.

Regards,

Andrey

MarcoWedel — Wed, 05 Apr 2017 22:17:41 GMT

devarasu07 — Thu, 06 Apr 2017 01:49:41 GMT

Hi,

If the issue got resolved, help to close this thread by marking correct or helpful

Thanks,

Deva