PivotTable View

  • Thread starter Thread starter Jasper Recto
  • Start date Start date
J

Jasper Recto

I have a query that gives me hours worked for a employee and the date.
The hours have 2 decimal places

When I pull this query into the pivot chart view, it rounds up the daily
hours and give me a completely different sum value.

For example, if I run the query, I get a value of 11.25 hours for a specific
date. When I view this in pivotTable view, the value is only 11.00. The
decimal place is being removed.

How can I prevent the pivot table view from doing that?

Thanks,
Jasper
 
Jasper Recto said:
I have a query that gives me hours worked for a employee and the date.
The hours have 2 decimal places

When I pull this query into the pivot chart view, it rounds up the daily
hours and give me a completely different sum value.

For example, if I run the query, I get a value of 11.25 hours for a specific
date. When I view this in pivotTable view, the value is only 11.00. The
decimal place is being removed.

How can I prevent the pivot table view from doing that?

Thanks,
Jasper
Click to expand...
 
Jasper Recto said:
I have a query that gives me hours worked for a employee and the date.
The hours have 2 decimal places

When I pull this query into the pivot chart view, it rounds up the daily
hours and give me a completely different sum value.

For example, if I run the query, I get a value of 11.25 hours for a specific
date. When I view this in pivotTable view, the value is only 11.00. The
decimal place is being removed.

How can I prevent the pivot table view from doing that?

Thanks,
Jasper


I am experienceing the same problem. Did you find a solution?
Click to expand...
 
Back
Top