Custom Data format for numeric currency value — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Custom Data format for numeric currency value

Received Response
1
Views
2
Comments
user13483708
user13483708 Rank 2 - Community Beginner
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

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

Answers