PriorityOne
New Member
- Joined
- Nov 6, 2014
- Messages
- 8
I am pulling data via odbc microsoft query. One of my fields has the formula Round(GL01+GL02+GL03, 2). It returns only two decimal places in the query, but creating pivot causes extraneous data after two decimal places. I then proceeded to add a column to results of the query rounding that field to 2 places and bring that field into query. I need to know why the following numbers do not add up to zero:[TABLE="width: 195"]
<tbody>[TR]
[TD="align: right"]
[/TR]
[TR]
[TD="align: right"]12913520.610000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]1824309.150000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-12913520.610000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-1824309.150000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-14736551.160000000000000
[/TD]
[/TR]
</tbody>[/TABLE]
The sum in my pivot table is [TABLE="width: 195"]
<tbody>[TR]
[TD="align: right"]
-0.000000003725290
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD="align: right"]
14736551.160000000000000
[/TD][/TR]
[TR]
[TD="align: right"]12913520.610000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]1824309.150000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-12913520.610000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-1824309.150000000000000
[/TD]
[/TR]
[TR]
[TD="align: right"]-14736551.160000000000000
[/TD]
[/TR]
</tbody>[/TABLE]
The sum in my pivot table is [TABLE="width: 195"]
<tbody>[TR]
[TD="align: right"]
-0.000000003725290
I have refreshed, deleted and started over. Removed the table associated with the Pivot and tried a smaller subset of the pivot.
If someone knows how to solve this, it would be appreciated. I told my wife I was going home an hour+ ago
Sorry for the formatting and thanks for the help!
-ZM
[/TD]If someone knows how to solve this, it would be appreciated. I told my wife I was going home an hour+ ago
Sorry for the formatting and thanks for the help!
-ZM
[/TR]
</tbody>[/TABLE]