Discrepancy in Total Values of Calculated Fields: QuickSight vs. Excel CSV Export

I’m facing an issue specific to calculated fields when exporting visuals to CSV format in QuickSight compared to Excel. While other data seems consistent, the totals of calculated fields differ between the two platforms. I’ve meticulously checked the calculations and ensured identical inputs, yet the mismatch persists. Has anyone else encountered this discrepancy with calculated fields? Are there nuances in how QuickSight and Excel handle these calculations that could explain the inconsistency? Any guidance on resolving this discrepancy would be invaluable.

@priyadarshini.m

Hi @DruthyS,

Would you be able to provide an example of the inconsistency with some sample data and screenshots?

Hi @DruthyS,
I’m just checking in on this question, as we have not heard back from you. We would still like to help. If we do not hear back in the next 7 days, we will archive the question.
Many Thanks,
Andrew

When exporting the QuickSight widget to CSV format and creating a pivot table, I noticed that the average values for columns such as CPM, CPC, CTR, and CPA do not match the original values displayed in QuickSight.

Attached is the screenshots for reference.

The original CPM must be 17.21 but getting 167.32