Exporting To Excel Changes Number Format
(Doc ID 2169637.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document