1 Reply Latest reply: Dec 7, 2012 3:27 AM by fac586 RSS

    Negative numbers in Parentheses() in Interactive Reports in Apex 4.1

    Diviya
      Hi,

      I want to display the negative numbers in parentheses() in all the interactive reports in my application eg: (367,432,203.07).

      I tried using the PR format "999G999G999G999G990D00PR" in my number/date format option in 'Column Definition'. But it gives the negative number '-367432203.06895' like this '<367,432,203.07>', which is not my exact requirement.

      Is there any other number format/option to get negative numbers in parentheses in my reports.

      Can anyone please help me on this?
        • 1. Re: Negative numbers in Parentheses() in Interactive Reports in Apex 4.1
          fac586
          divya wrote:

          I want to display the negative numbers in parentheses() in all the interactive reports in my application eg: (367,432,203.07).

          I tried using the PR format "999G999G999G999G990D00PR" in my number/date format option in 'Column Definition'. But it gives the negative number '-367432203.06895' like this '<367,432,203.07>', which is not my exact requirement.

          Is there any other number format/option to get negative numbers in parentheses in my reports.
          No. In 4.1 the only way to do this that preserves IR sort/aggregation/calculation functionality is to manipulate the values using a Dynamic Action/JavaScript after the page is rendered. This is not really satisfactory.

          In 4.2 I think it might be possible using a lot of extra columns, HTML Expressions, and CSS.