on 05-17-2016 10:29 PM
I exported some data from a information space to .csv and the same to excel.
I notice for one of the columns where the data is stored with 4 decimal places, the one in .csv shows only 3 decimal places when i open it in notepad or excel.
The same data which i exported in excel shows 4 decimal places as stored in the database.
In the universe the object is formatted to show 4 decimal places.
I appreciate any reply for the mismatch of this behaviour. My environment is BO 4.1 SP6 Patch 4.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tagu Tagu,
It seems that when you export decimal numbers to csv format, 'export engine' formats these numbers into "-#,##0.###" format (you should see these 3 decimals : .### ). This format is fixed.
Arnaud
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.