Custom Data format for numeric currency value

Question

Hi ,

I have a  data in one of the reports in OBIEE as below

£1200.00

-£3209494.00

£0

£19999.00

-£199.00

Currently I have a set the Data Format as currency and its displaying as above.

My requirement is I want to display the negative numbers in RED and '£' should appear outside Bracket

I am trying something from the one of the previous discussions but its not helping. £0 figure is not appearing.  I have put the below condition in Custom Data format

[>0]£#;[<0]£(#)

What I am getting is

£1200

£ (3209494)

£

£19999

£199

Thanks

Raj

Thanks

ArijitC · Answer

Try this

£#0 ; £(#)

To Set the color RED you need to use conditional formatting.

cesar.advincula.o · Answer

you can try something like [>0]£#.00;[<0]£(#.00);£#.00 , and use a conditional format to show as a red number.