topic rounding off a value in Application Development and Automation Discussions

rounding off a value

Former Member — Mon, 04 Jun 2007 05:22:45 GMT

i have an amt field of currency type.

i want to round off the value like if the value is 2019.50 then it shud be

2020.00 . how can i do it..

Thanks

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 05:24:41 GMT

Use the aggregate function RND

RND(value).

Thanks

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 05:27:06 GMT

try this

DATA: I TYPE I,

P TYPE P DECIMALS 2,

M TYPE F VALUE '-3.5',

D TYPE P DECIMALS 1.

I = CEIL( P ). " 4 - next largest whole number

I = CEIL( M ). " -3

I = FLOOR( P ). " 3 - next smallest whole number

I = FLOOR( M ). " -4

I = TRUNC( P ). " 3 - integer part

I = TRUNC( M ). " -3

D = FRAC( P ). " 0.5 - decimal part

D = FRAC( M ). " -0.5

regards

shiba dutta

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 05:27:19 GMT

check the following Functions

following maths functionas are there in SAP:

abs -Absolute value of the argument arg

sign- Plus/minus sign of the argument arg: -1, if the value of arg is negative; 0 if the value of arg is 0; 1 if the value of arg is positive.

ceil -Smallest integer number that is not smaller than the value of the argument arg.

floor- Largest integer number that is not larger than the value of the argument arg.

trunc- Value of the integer part of the argument arg

frac- Value of the decimal places of the argument arg

Reward points if useful

Regards

Anji

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 05:30:24 GMT

Hi,

hope u can use the function module ROUND.

Reward points if it is helpful.

Regards,

Sangeetha.

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 14:23:37 GMT

Hi,

Use ROUND aggregate function.

Ex.

DATA pack TYPE p VALUE '123.456'

DECIMALS 3.

WRITE pack DECIMALS 2.

WRITE: / pack ROUND -2,

/ pack ROUND -1,

/ pack ROUND 1,

/ pack ROUND 2.

Output:

123,46

12.345,600

1.234,560

12,346

1,235

Regards,

Bhaskar

Re: rounding off a value

Former Member — Mon, 04 Jun 2007 14:55:02 GMT

check the Fm Round_amount.

or ..

logic has to be build this way

parameters : price like vbap-netwr .

data : val type i .

data : rem type p decimals 2.

rem = frac( price ).

rem = rem * 100.

if rem ge 50.

val = abs( price ).

move val to price.

write price.

else.

write:/ price.

endif.

like if the input is 2019.20 o/p will be 2019.20 only

if the input is 2019.51 o/p will be 2020.00.

check this .

try the variation

write value curreny 'X' round 'Y' DECIMALS 'Z'.

CHECK this option as well.

Vijay

Re: rounding off a value

Former Member — Thu, 21 Jun 2007 15:43:06 GMT

Thanks for the post! Just what I needed!