Hi,
I have a report with metrics and enabled to show two decimals. When I export the data in csv, the decimals are showing more than 2 decimals. While excel export shows whatever decimals I have selected in analysis.
For CSV export, is this expected behavior or need to do some settings for csv options.
Hi,
The format just affects the visual representation of the data. The underlying data still has the full number of decimal places. When you export to CSV, it’s returning the actual data. This is also true for the Excel export, except that if you look at the data, you’ll see that a “custom” format has been applied, i.e. something like “#,##0.00;-#,##0.00”. So you’ll see the data represented with two decimals. If you change the format, you’ll see more (or fewer) decimals depending on the format. Hope that makes sense.
-Santosh
Hello @hanumantha.muchumari !
Did @xnairsan 's post help you solve this issue and if so could you mark their post as a solution to help the community?
We have not heard from you in a few days but would still like to help find a solution. If we do not hear back in 3 days this post will be archived.
Hi,
Yes, even though we apply custom format, export csv will have actual decimal places which is coming from database. Export excel will have whatever custom format we apply. I verified this for multiple reports.
Thanks
Hanumanth