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:
<tbody>
</tbody>
The sum in my pivot table is
<tbody>
</tbody>
14736551.160000000000000 |
12913520.610000000000000 |
1824309.150000000000000 |
-12913520.610000000000000 |
-1824309.150000000000000 |
-14736551.160000000000000 |
<tbody>
</tbody>
The sum in my pivot table is
-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 |
<tbody>
</tbody>