the data and the number of decimal changed when import data

[JoeyZ]

When I import data into QlikView, the data and the number of decimal places in the original data changed.

original data( the number of decimal :2)

1,120,201,000,348.54

the data in Qlikview( the number of decimal :3)

1,120,201,000,347.376

is there any idea about it ?

[BrunPierre]

Format it like this.

Num(Field, '#,##0.00')

[JoeyZ]

thank you for your replying. I tryied it ,but the result is different.

I found the reason of this problem,and  I think it is a bug in Qlikview:

<reason>

If you import data with two decimal places into QlikView and display the total in an analysis box, there is a possibility that the total value may be incorrect. This is because QlikView may incorrectly round or display decimal places.

<For example>

suppose you have the following data:

items	num	price
A	1.005	1.99
B	2.01	3.49
C	3.003	0.99

sum up the price or sum up (num*price)
the result in Qlikvie is different from the correct result.

Best regards,