Microsoft Excel - Pivot Table/Rounding
Asked By Erika O'Brien on 23-Nov-10 01:59 PM
So, I am using one pivot table for multiple data pulls in a single file/spreadsheet. Example I have 3 sites....Texas, Indiana, Utah. I populate my pivot table to pull just Indiana info....paste it into another sheet.....I re-populate my pivot and do the same for Texas and Utah....then I create a pivot table to just pull Texas and Indiana.....off to the right of my pasted pivot information I have some formula's that divide....example Profit per Hr. I think because the original pivot table is not rounding and carrying the number out to the 10th decimal....my numbers are slightly off. So, hours of (288 +388)/(9438.44+6703.98) Profit = $23.88......my pivot gives me $24.52. Do you think I am right and this is a rounding issue? If so how do I fix? E.