If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Table rounding
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 |
#2
|
|||
|
|||
Pivot Table rounding
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? Ben |
#3
|
|||
|
|||
Pivot Table rounding
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 -- KN |
#4
|
|||
|
|||
Pivot Table rounding
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. "Krzysztof Naworyta" wrote: 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 -- KN . |
Thread Tools | |
Display Modes | |
|
|