Exporting To Excel Changes Number Format
Last updated on FEBRUARY 03, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.5 and later
Information in this document applies to any platform.
When export an OBIEE analysis with custom data format, it shows incorrect dollar amounts in Excel.
1. Create a report with a couple of columns and a measure column with dollar amount.
2. Add a custom data format to the dollar amount column.
Data Format : $#,#,
3. Save the report and export results to Excel.
4. Notice 9526 shows as $10
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms