Missing cents in the pivot table

[Guest]

Hello!

Why doesn´t the pivot table show cents when this is the fact in the
underlying data sheet?

The amount in the data sheet is 73640,75 SEK and this is presented as 73640
SEK in the pivot table.It seems like the amount gets truncated in the pivot
table.

I´ve changed the field property to two decimals in the query but this only
changes the appearance in the data sheet.

 

[Vincent Johns]

There isn't enough information here for me to determine the cause of
your problem. Sample data, plus your SQL, might help.

Generally, no, a Crosstab Query does NOT gratuitously truncate
fractional values to integers. But somewhere you may have declared some
field as an integer type and the fraction got lost there. (I don't know
if that be the case with your database, but it sometimes happens.)

When you say, "this only changes the appearance in the data sheet," does
that mean that the fractional part reappears? I assume not, but then
what do you mean? How does the appearance change?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.