Pivot Chart View
in [General]
|
From: Jasper Recto on 2 Jul 2008 13:00 I have a query that gives me hours worked for a employee and sums them up. It has 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. How can I prevent the pivot chart view from doing that? Thanks, Jasper
From: Ton Baars on 2 Jul 2008 13:35 "Jasper Recto" <jrecto99(a)yahoo.com> schreef in bericht news:OZkVwUG3IHA.1196(a)TK2MSFTNGP05.phx.gbl... >I have a query that gives me hours worked for a employee and sums them up. >It has 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. > > How can I prevent the pivot chart view from doing that? > > Thanks, > Jasper >
|
Pages: 1 Prev: formatting a date in a text field Next: How to Handle Feb 28 and 29? |