topic Re: Decimal- Currency Division problem in Application Development and Automation Discussions

Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 05:55:01 GMT

Hi All,

I want to divide the Currency value by decimal value.

When i try to it, it returns the rounded value and not the exact value.

For ex:

data: sal like pa0008-bet01 value '50570.06',

amnt type decimals 2 value '57462.23',

ans TYPE p LENGTH 11 DECIMALS 2.

ans = ( sal / amnt ) * 100.

write:/ ans.

It returns 0.01 and it should be 88.01

Thanx in advance

Re: Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 06:09:54 GMT

The following code it returns 88.01

data: sal like pa0008-bet01 value '50570.06',

amnt type p decimals 2 value '57462.23',

ans type p decimals 2.

ans = ( sal / amnt ) * 100.

write:/ ans.

Just execute the above code.

Regards

Raja.

Re: Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 06:11:19 GMT

Hii ..check with the amount declaration

amnt type p LENGTH 8 decimals 2 value '57462.23'

Rgds,

Re: Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 06:16:37 GMT

Hi,

ans type p decimals 2 , would solve ur problem.

Regards.

Re: Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 06:17:55 GMT

Hi,

In your code change this

amnt type decimals 2 value '57462.23',

to amnt type p decimals 2 value '57462.23',

it will work out.

Re: Decimal- Currency Division problem

Former Member — Tue, 24 Jun 2008 06:19:14 GMT

Hi,

Jus try this...

data: sal like pa0008-bet01 value '50570.06',

amnt type p decimals 2 value '57462.23',

ans TYPE p LENGTH 11 DECIMALS 2.

ans = ( sal / amnt ) * 100.

write:/ ans.