I have a requirement where i need build a report in XML Publisher using Data Definition and RTF Template, where the default output type is MS Excel.
For a amount column we need to show the negative amount within bracket eg. -100 to (100) and for blank or 0 amount it should show a hyphen "-".
I tried using the RTF properties feature "$#,##0.00;($#,##0.00)", and its working fine except it include a $ sign with the amount like ($100).
Can someone help to achieve this with a $ sign for negative amount and for blank and zero amount it should show a hyphen "-" sign, Also it should work for summing up the column as well
Note: This feature is available with MS Excel document when we enter the data manually.