topic Re: round decimal in Application Development and Automation Discussions

round decimal

Former Member — Thu, 04 Jun 2009 09:35:21 GMT

i have the number type p decimals 2

I want that when tnat for 2 I make a commercial rounding.

es. 1,99 ---> 2 .

there is an istraction.

Former Member — Thu, 04 Jun 2009 09:37:30 GMT

Please try ROUND_UP for rounding to next integer and ROUND_DOWN to round to previous integer.

Regards

Gaurav.

former_member222860 — Thu, 04 Jun 2009 09:37:58 GMT

Use CEIL() function

data: f1 type p decimals 2 value '1.99'.

f1 = ceil( f1 ).

write:/ f1.

Pl. search , you'll find lot of threads on this

Former Member — Thu, 04 Jun 2009 09:42:47 GMT

try to use

'CEIL'(Smallest integer value ) 'FLOOR'(Largest integer value) and 'TRUNC'(Integer part of argument )

data: t1 type p decimals 2 value '1.99',

t2 type i..

t2 = ceil(t1).

t2 = floor(t1).....

Edited by: mayank jain on Jun 4, 2009 11:43 AM

Edited by: mayank jain on Jun 4, 2009 11:47 AM

Edited by: mayank jain on Jun 4, 2009 11:53 AM

Former Member — Thu, 04 Jun 2009 09:46:12 GMT

DATA : INT TYPE I,
       DEC TYPE P Decimals 2.
DEC = '1.99'.
INT = DEC.
WRITE:/ DEC,INT.
DEC = '1.49'.
INT = DEC.
WRITE:/ DEC, INT.

Former Member — Thu, 04 Jun 2009 10:13:04 GMT


DATA: I TYPE P,
      J TYPE P.
I = '12.712324'.
WRITE: / I ROUND 0 DECIMALS 4.
J = '12.336216'.
WRITE: / j ROUND 0 DECIMALS 4.