topic Re: decimal issue when dividing in Application Development and Automation Discussions

decimal issue when dividing

Former Member — Wed, 05 Sep 2007 06:30:12 GMT

Hi ,

price is in curr with 2 decimals, while qty is in data type DEC, 5.

cal = ( price / qty )

i want to get the calc in 3 decimal points.

when i put calc as p decimal 3 it gave a different value.

Eg, 58.467/10 gave as 0.585 where as it should be 5.847

Can any one advise as to which data type i should use for calc field.

Thanks

Keshi

Re: decimal issue when dividing

Former Member — Wed, 05 Sep 2007 06:51:30 GMT

data : l_price type bseg-dmbtr,

l_qty type p decimals 5,

l_cal type p decimals 3.

l_price = '58.467'.

l_qty = 10.

l_cal = l_price / l_qty .

WRITE 😕 l_cal.

Re: decimal issue when dividing

Former Member — Wed, 05 Sep 2007 08:09:51 GMT

Hi,

the problem is with the attribute of the program where your are writing the code for division.

open the prog in SE38 and check the Fixed point arithmetic parameter - i guess u ll find it dechecked. To get proper result u need to have it checked.

if you are inside a customer exit/include then you will have to create a function module for doing the calculations and related stuffs.

hope it solves ur prob.