Pivot table inaccuracies
Pivot table inaccuracies
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot table inaccuracies

  1. #1
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello,

    I've posted this to the Excel programming newsgroup but I'll put it here as well just to get a wider audience.

    I have a pivot table with an Access database query as it's source. In the
    pivot table some numbers are shown to 10 decimal places e.g.
    35657.8299999998 but ONLY in the formula bar. In the table it is shown
    correctly as 3567.83 exactly. The source records making up this total are
    financial transactions (pounds and pence) and are therefore all at 2 decimal
    places (I have checked that this is the case). Is this a known problem and
    does anyone have a solution/workaround?

    Excel 2000/Access 2000/Windows 2000 Pro


    Cheers,
    Dan.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just noticed an error with that. In the table the amount shown is 35657.83, not 3567.83 as originally stated.

    Regards,
    D

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Please ignore my posts - I'm being thick

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com