Missing cents in the pivot table from a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
I am having the the exact same problem except mine is showing 2 decimals and
I don't want any. Have you gotten this resolved?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing cents in the pivot table 1
Access #Error & Excel Pivot 0
Is there a way of not showing zero totals in a pivot table? 2
How do I use pivot table data for further calculations? 2
Percentages in Pivot table 2
Pivot Table Question 1
Excel Error while updating an external data source into a pivot table! 0
Wrap Text in Access Form Pivot table 0

Back
Top