Skip to Main Content
Forums

APEX

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!

Display float numbers in APEX report

Giedrius S.Jan 9 2014 — edited Jan 10 2014

Hello,

  I have an  interactive report and simple report based on a table with float numbers. Problem is, float numbers with value between 0 and 1 are shown ".1" not "0.1"

For example, for values 0.1, 1 and 12.1 I get:

.1
1
12.1

  If I add format mask FM999999999999990D99999 to this field, I fix ".1" value, but value "1" becomes "1." which is bad:

1

0.1
1.
12.1

What I would like to see in a report is:

0.1
1
12.1

How could I do it?

I wrote function which makes needed result as a varchar2 value. Data in reports shows fine, but then problem with sorting arised - data is being sorted as text, not as number, for example:

1.1
11.2
7

Any ideas?

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2014
Added on Jan 9 2014
#apex-discussions
16 comments
1,219 views