You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Global default for negative number format in Reports, or a way to bulk-update existing reports?

Summary:

Hi all,

We use Oracle EPM Cloud Planning [module-Financials] with the Reports module (Report Designer). We want negative values, mainly revenue, to display in one consistent style in reports (for example brackets and a specific color).

What we know:

  • Application → Settings → Number Formatting sets the negative sign and color. We use that for forms, dashboards and Smart View sheets, and we need a different format in reports.
  • In Report Designer, negative prefix/suffix and “negative in red” are cell/grid properties, set report by report. “Use default” only seems to cover the thousands and decimal separators.
  • For Financial Reporting, the Default Formatting Preferences only apply to newly created reports, not existing ones.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!