0 Replies Latest reply: Apr 25, 2014 1:43 AM by 885157 RSS

    In XML Publisher Report using RTF template how to generate the negative amount within bracket ().

    885157

      Hello Everyone,

       

      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.

       

      Example:-

      59.65
      (49.71)