BI Publisher (MOSC)

MOSC Banner

How to format the numbers into Excel's Accounting format in Publisher basic templates ?

in Oracle OAC, BI Publisher report


I am developing a report layout in BI Publisher report basic template:


I would like to use a specific Format Number Mask in BI Publisher Basic template , that is possible to set in the layout, as in the image below:

to have as result of the execution of Publisher report an export in Excel where for some of the columns I have in the report the Data Formatting should be in Accounting format as in the screen shot below that represents an example of excel file columns:

When the value is '0' I would like to see a minus (-)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center