Strange Decimal Number

[Anonymous]

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]

Hi,

Try like below,

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

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

[sarvesh]

Could you share that data with me.

[tresesco]

A good read would be: Rounding Errors

[devarasu07]

Hi,

[ahaahaaha]

Hi Chou,

Like all right  you (look attached file).

You need to analyze the data.

Regards,

Andrey

[MarcoWedel]

see also:

Rounding differences between QV 11 & 12

regards

Marco

[devarasu07]

Hi,

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

Thanks,

Deva