Excel Pivot gives slightly different numbers for Sum

[grifter]

Version: Excel 2007

Hi

I have a report in business objects that I have created as a cross tab with department on one side and sum of item on other side.

When I extract the raw data and pivot it in Excel I get slightly different numbers when I sum. If I count the items it matches.

The difference is only a small amount, like 1% and less. I have verified that the SQL data in the background is the same as in the BO report so I can't figure out why the sum is slightly different in excel.

Any thoughts on this would be greatly appreciated.

G

 

[CazB]

My initial thought: could it be down to rounding?

 

[grifter]

My initial thought: could it be down to rounding?

One of my figures is 5694 from the database but in excel is 5641, maybe so I don't know? The imported numbers are already whole numbers with no decimals. If I add decimals in excel they are all .00 so there's definitely no extra values hiding in the background. Maybe it's doing something in the DB.

Thanks
G

 

[grifter]

The problem is due to duplicates in our DB. In BO the data is not shown as a duplicate, and in the report I have a date difference days value, which I then sum in BO. When I do this it adds the duplicates in the DB but when I save the data to excel it only adds the value that was shown i.e. the single row data.

Something to watch if you have duplicates in DB, they will not show in the BO report but any summing will add duplicate numbers up.