Number not exactly the same as source data

building reports desktopintelligence
1

Hi all,

we use cvs file as data source to populate the deski report (pivot table).

However, the summation shown in the report is not equal to the summation in the cvs file. Usually, the reported amount is a few hundres less than the actual amount.

We suspect that the Deski truncate the each numbers for integer value before adding up everything.

Does anyone have any idea about what is happening here?

thanks.

abcjc110 (BOB member since 2011-07-01)