OraFAQ Forum: Forms » How to Round Off # of digest after decimal in Number Field.

Home » Developer & Programmer » Forms » How to Round Off # of digest after decimal in Number Field.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Round Off # of digest after decimal in Number Field. [message #121607]

Tue, 31 May 2005 01:22

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

A number field takes value form division of two other fields.
I want to restrict number of digit after decimal = 2.

Example:-
13 / 3 = 4.333333333333333333333333333

I want it to be
13 / 3 = 4.33

It wont hurdle the database as database fields are restricted to number(10,2) they only accept 2 digit after decimal but it wont even look good when such values display in form.

So there any way to apply rounding and avoid unnecessary long display.

Wishes
Jawad

Report message to a moderator

Re: How to Round Off # of digest after decimal in Number Field. [message #121666 is a reply to message #121607]

Tue, 31 May 2005 06:58

A Ikramur Rahman
Messages: 81
Registered: May 2004

Member

Use "Format Mask" ITEM Property.

Report message to a moderator

Re: How to Round Off # of digest after decimal in Number Field. [message #121669 is a reply to message #121607]

Tue, 31 May 2005 07:10

weekend79
Messages: 198
Registered: April 2005
Location: Islamabad

Senior Member

HOW?

Report message to a moderator

Re: How to Round Off # of digest after decimal in Number Field. [message #121670 is a reply to message #121607]

Tue, 31 May 2005 07:18

A Ikramur Rahman
Messages: 81
Registered: May 2004

Member

Set the format mask property of the number type item to 99999.99
(or as per your requirement)

Report message to a moderator

Previous Topic:	see how you display column in report according to user choice(by asking user)
Next Topic:	Getting Database trigger value in oracle forms 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 21:19:07 CDT 2024