topic Re: how to devide in Application Development and Automation Discussions

how to devide

Former Member — Thu, 22 Oct 2009 11:04:21 GMT

hi,

i have facing a probleam with deviding the two values.

How to devide this two values. Because u2018,u2019 creating probleam here. because i am etting the error that its not a number

so here i have different different values there in database table .

ex:

t_konv-kbetr : 52,367.30

t_konv-kpein : 1,000

please help?

Re: how to devide

Former Member — Thu, 22 Oct 2009 11:07:51 GMT

Well then just replace the commas and divide


data: result type p decimals 2.

t_konv-kbetr = 52,367.30 .

t_konv-kpein = 1,000.

replace all occurences of ',' in t_konv-kbetr with space.
replace all occurences of ',' in t_konv-kpein with space.

result = t_konv-kbetr / t_konv-kpein.

Re: how to devide

Former Member — Thu, 22 Oct 2009 11:13:29 GMT

I guess u shud not be getting any such errors.

Just define the result variable as say TYPE p decimals 2 and straight away write

result = t_konv-kbetr / t_konv-kpein.

I will recheck the results but it shud work.

Re: how to devide

Former Member — Thu, 22 Oct 2009 11:17:38 GMT

Hi,

You can use below BAPI to convert the amount into desired format:

BAPI_CURRENCY_CONV_TO_INTERNAL

Regards,

Nitin.