BI Publisher (MOSC)

MOSC Banner

Format negative number at rtf template

edited Apr 7, 2013 8:33AM in BI Publisher (MOSC) 3 commentsAnswered
Hi all,

I want to display negative number with bracket but without negative sign at report output. How can it be done at rtf ?

For normal number, I can simply add this format #,##0.00;(#,##0.00) at bi publisher properties. So if the number is negative, it will display with bracket and without negative sign '-'.

How about it is running total and I use "show-page-total" and "show-carry-forward" to show the number ?

For example:

<xdofo:show-carry-forward name="EntAmt" format="99G999G999D00"/>

<xdofo:show-carry-forward name="PS" format="99G999G999D00"/>

I do not have any idea to format the negative number.

Thanks so much

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