APEX

Hi all,

I am hoping that someone will be able to assist me with a Number Formatting issue I'm experiencing using APEX 3.0.1.

I have a report display a financial amount and a percentage column and I want to display totals for both these columns with appropriate signs - local currency for fiscal amounts and percentage sign (%) for the percent column.

The financial column is easy as it is included in the seeded number formats available but I don't believe there is a format modifier for the % sign. I have achieved displaying the percentage sign at individual row level by adding #PERCENT#% to the HTML Expression of the Report Column Attribute.

......    <Fin Col>   <% Col>
         ----------          -------
        $1,230.00          0.01%
            $30.55         15.00%
        $1,000.00          3.00%
        $2,263.55          18.01 <-- Missing % sign in sum row

However the percentage sign does not appear in the calculated sum total row.

Doing a TO_CHAR in the actual SQL Query for the percentage column means that the sum row always returns 0 (zero).

Does anyone know how I'd be able to achieve the formatting at a sum row level for the percentage column?

Kind Regards,
Gary.