When A Financial Reporting (FR) Report Is Exported To Excel, Negative Numbers Are Formatted As Text (Doc ID 1505555.1)

Last updated on DECEMBER 21, 2012

Applies to:

Hyperion BI+ - Version 11.1.2.1.125 to 11.1.2.1.128 [Release 11.1]
Information in this document applies to any platform.

Symptoms

You've created an FR report which pulls some data values that are negative and display with a "-" sign in front of the number.  When this report is exported to Microsoft Excel, the negative numbers are formatted by Excel as text.

Consequently:

1) The values cannot be summed up ("-123" becomes " '-123")
2) The values are given a "," as a Thousands delimiter ("-123456" becomes "-123,456")


Cause

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