Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Problem with Exporting Numbers to Excel
Migrateduser
Hello,
I have a BIRT report that I use to extract 3 computed columns with type "Decimal". They display in the report without any problems but I need to elaborate on them in Excel. OK, so I export to Excel and I open the file. The number values are there, but they are not recognised as numbers in Excel. They are listed as numbers stored as text. In order to use them, I have to select the cells and click on "Convert to Number".
Why is this happening? The computed column in the dataset has type "Decimal" (I have tried Float and Integer as well) and in the editor presentation the cells are formatted as "Fixed" with 0 decimal places.
What can I do?
Thank you!
Andrew
Find more posts tagged with
Comments
There are no comments yet