Pivot Table rounding

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

I setup a pivot table in Access. The property for the values is two decimal
places. When I view as a Pivot Table, Access is rounding the stored values.
When I look at the data in datasheet view, the values aren't rounded.

Any idea how to stop the pivot table from rounding?

Ben
 
For example, I have the following values in the field CMSN_AMT: 366.10;
188.34; 24.95. When I view these values in the Pivot Table (to sum CMSN_AMT)
by other filters, the values show as 366.00; 188.00; and 24.00; respectively.

Any ideas? The correct numbers are displayed in Datasheet view - just not
as a Pivot Table.

Thanks
Ben
 
Ben wrote:
| I setup a pivot table in Access. The property for the values is two
| decimal places. When I view as a Pivot Table, Access is rounding the
| stored values. When I look at the data in datasheet view, the values
| aren't rounded.
|
| Any idea how to stop the pivot table from rounding?

In PivotView click your value, properties > format > number format
 
Tried that - didn't work.

For example, I have the following values in the field CMSN_AMT: 366.10;
188.34; 24.95. When I view these values in the Pivot Table (to sum CMSN_AMT)
by other filters, the values show as 366.00; 188.00; and 24.00; respectively.
 
Back
Top