Skip to Main Content

Analytics Software

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!

How to change the display of a positive number to a negative number on the report layout

User_JL3CWAug 26 2018 — edited Oct 7 2018

Hi All,

I have report having account in rows section and accounting period in  column section.

My report values is require to display -ve numbers (default +ve number values).

For example Particular Parent Account is having multiple account rows. I have used Descendants function for particular parent (CCEQU - Parent defined in the hierarchy). CCEQU has many child records. How to change sign from +Ve to -Ve in the FR Studio?

In the formula i am able to change by multiplying with -1. Here i am doing for every row. It's high difficult to change all the rows manually. Any technique?

Please advice.

Regards,

CK.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2018
Added on Aug 26 2018
5 comments
2,626 views