Format negative number at rtf template
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