PivotTable View

[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

 

[Leezet Llorance]

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

 

[Leezet Llorance]

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?