topic Re: Problem in dividing the value in Application Development and Automation Discussions

Problem in dividing the value

Former Member — Mon, 04 May 2009 08:59:41 GMT

Hi,

I have a problem in dividing the values, say example i want to divid n by n1.

n = 1339.80

n1 =1914

n2 = n/n1

but i am getting the output value as 1 and i tried the DIVIDE statement as well, but still i am facing the same proble.

Please help to solve this problem

Let me know the FM to calculate the percentage value.

Regards,

Vijay

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:03:04 GMT

try declaring all the three variables as type P (Packed decimals) and perform the division.

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:05:04 GMT

Hi,

Take the Type of the N2 as Decimal or Packet.

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:05:11 GMT

Hi,

What is the data type of n and n1?

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:05:13 GMT

seems like you have declared you variables of type i.

Re: Problem in dividing the value

former_member222860 — Mon, 04 May 2009 09:06:56 GMT

Check this:

data: n1 type p decimals 2,
      n2 type p decimals 2,
      n3 type p decimals 2.

  n1 = '1339.80'.
  n2 = '1914.00'.

  n3 = n1 / n2.

  write:/ n3.

thanks\

Mahesh

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:07:22 GMT

hi,

Declare it of type p and after division you can store in the data type of your choice.

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:09:19 GMT

the problem may be that the variable n2 is int type.

if you want an answer in decimal format then just make this variable of type p(packed decimal) and i you want an integer output then in sap 5/10 is 1 not 0.

use ceil or other similar commands.

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:21:15 GMT

Hi,

Please check the following code, it is working fine.

PARAMETERS:n type p decimals 2 DEFAULT '1339.80',

n1 type p decimals 2 default '1914',

n2 TYPE p DECIMALS 2 .

n2 = n / n1.

WRITE n2.

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 09:44:38 GMT

Hi,

I try using the one you suggested as well and all other ways. but i am not getting the solution.

Is there any FM to calculate the percentage.

Regards,

Vijay

Re: Problem in dividing the value

GauthamV — Mon, 04 May 2009 09:48:19 GMT

Try this.



Data: n type p decimals 5,
      n1 type p decimals 5,
      n2 type p decimals 5.

n = '1339.80'.
n1 = 1914.

n2 = n / n1.

write: n2.

Re: Problem in dividing the value

former_member222860 — Mon, 04 May 2009 09:54:18 GMT

It gives percentage value

data: n1 type p decimals 2,
      n2 type p decimals 2,
      n3 type p decimals 2.

  n1 = '1339.80'.
  n2 = 1914.

  n3 = n1 / n2 * 100.

  write:/ n3.

And what's the error your getting.

thanks\

Mahesh

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 10:46:11 GMT

Hi all,

When i try hard code the value with the solution given is working. but the problem in my case is

DATA: n TYPE p DECIMALS 2,

n1 TYPE p DECIMALS 2,

n2 TYPE p DECIMALS 2,

n3(10) type c value '1339.80',

n4(15) type numc valu '1914'.

Note for n3 and n4 is hardcode for examplet, but in real time , the value will be passed from the field directly.

n = n3 .

n1 = n4.

n2 = n/ n1.

write n2.

Please check and let me know the solution for this case.

Regards,

Vijay

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 10:54:01 GMT

Hi,

I have tested the code and it is giving the output as 0.70.(i.e. N2 hold 0.70 value)

Re: Problem in dividing the value

Former Member — Mon, 04 May 2009 12:48:32 GMT

Hi,

Yes its coming correct if you pass the value without decimal for n4 and the field type CURR.Please find the logic below

DATA: n TYPE p DECIMALS 2,

n1 TYPE p DECIMALS 2,

n2 TYPE p DECIMALS 2,

n3(10) type c value '1339.80',

n4 type netwr value '1914.50'.

Note for n3 and n4 is hardcode for examplet, but in real time , the value will be passed from the field directly.

n = n3 .

n1 = n4.

n2 = n/ n1.

write n2.

Kindly check and help me out to solve this.

Regards,

vijay

Re: Problem in dividing the value

Former Member — Thu, 07 May 2009 06:41:16 GMT

Hi all,

Here is the solution

data: n1 type p decimals 2,

n2 type p decimals 2,

n3 type p decimals 2.

n1 = '1339.80'.

n2 = '1914.50'.

n2 = n2 * 10.

n2 = n2 /1000.

n3 = n1 / n2.

write:/ n3.

then it will work correct in the case of the field has different type like CURR,CHAR,INTE,etc.

Any way thanks a lot for all.

Vijay