Dashboards & Reporting

Edyta7510
Guide

Different total after exporting report data

Hi All, 

 

Has anyone experienced the following? 

I have created a deal report on my dashboard. The total shows the sum of "amount in company currency" property. The total is X. 

When I extract data of this report into a spreadsheet, the total is out of a sudden 2M bigger than X. 

 

I brought this up with HubSpot support, but they don't seem to find a reason for this 😞 

Any thoughts/advice from the community? 

 

Edyta

0 Upvotes
2 Replies 2
Edyta7510
Guide

Different total after exporting report data

Thanks @webdew 

I managed to find a reason why this was happening. 

There were a few deals with 2 line items (same item from product library but slightly different prices). 

Sales agreed to X amount at Y price and Z amount at Y-5 price. 

Those types of deals were then duplicated in the xls. 

It doesn't solve my problem fully, but at least I know where this delta is coming from. 

webdew
Guide | Diamond Partner
Guide | Diamond Partner

Different total after exporting report data

Hi @Edyta7510 ,

Tried exporting a report data but it's working fine for me. Check below two screen shots: 

webdew_0-1643690680355.png  

webdew_1-1643690694590.png

I will advise you to try exporting different-different reports and is every time you are seeing the same error?

Regards.