Search This Blog

Sunday, June 30, 2013

Format negative numbers with bracket in ADF screens.

In Financials, it is important that negative numbers are displayed/formatted within brackets or braces.

Challenge comes in when the the column or UI attribute holds both positive and negative number.

Solution : On the UI Attribute, place with pattern as "#,##,###.00;(##,##,###.00)"
Or
If the UI is based on a VO, edit the attribute properties and specify the below details as part of the Control Hints. without the double quotes formattype as "Number" and format as "#,##,###.00;(##,##,###.00)"

The key here is semi-colon(;) seperating the value of the format, ADF internally recognizes that the second format value is for negative number.

No comments:

Post a Comment