APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Format Negative Report Numbers with Parenthesis

674728Jun 18 2010 — edited Sep 30 2010

I'm using Application Express Version 3.2.1.00.11. Users (accountants) want to see negative currency with parenthesis -- like what's possible with Excel. A negative number should look like ($99,217.90). I'm searching for a way to do this in a native ~apex~ way. The closest I've come is using a number format like "FML999G999G999G999G990D00PR". which puts numbers in angle brackets. Unfortunately that's not what's wanted.

I've looked at fudging the format by using something like this in the report query for the column

CASE SIGN(:num)
WHEN -1 THEN '('||TO_CHAR(:num,'FML999G999G999G999G990D00')||')'
ELSE TO_CHAR(:num,'FML999G999G999G999G990D00')
END

which works for Excel exports but breaks the Apex "COMPUTE SUM" report column functionality.

What to do?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2010

Added on Jun 18 2010

#apex-discussions

13 comments

8,784 views