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!

Rounding off the number to the nearest million

user8708843Oct 24 2011 — edited Oct 24 2011
Hi All,
I have numbers like $1000000, $12000000, $13989098 on my report.

Now the requirment is I want to see these numbers to be rounded off to the nearest million..

for example:

1) $1000000 should be shown as $1.00M
2) $12000000 should be shown as $12.00M
3) $13989098 should be shown as $13.98M

Please suggest me a way to get the above thing working.

Thanks in Advance..
This post has been answered by Amith Y on Oct 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details