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 (-)