Number columns are in text format in Excel export
Hi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculations on number columns, but the columns are in text format and when the user tags a couple of Excel cells, they only count, the average and sum are not calculated (this is a good way of checking the cell format).
There is a function in Excel (NUMBERVALUE) which can be used to convert the data into numbers, and it works, but we need more permanent solution for the users.
Best Answer
-
Hi,
If you build your template as an excel template, rather than other type of template such as RTF or online layout editor, then you can make it so that column in your excel output is data type number not text.
See
Oracle® Fusion Middleware
Report Designer's Guide for Oracle Business Intelligence Publisher
12c (12.2.1.3.0)
E80602-02
September 2017
Creating Excel Templates
0
Answers
-
Hi Nathan,
we did as you instructed, we created an Excel template and uploaded it to a new report and now it downloads as numeric data which is calculable.
Thank you for your help!
Ante
0