topic Re: help in SUM in Application Development and Automation Discussions

help in SUM

Former Member — Wed, 21 May 2008 14:23:19 GMT

Hi,

i Have table like below and i wont to sum the last Colman (c_hr)

to 1 field cnt What is the Best Way to do That?

Regards

Data cnt type P DECIMALS 2.

*Date               a_hr      b_hr    c_hr* 
*20040101	 9.00	   9.00	   1.00*
*20040105	 5.00	   9.00	   0.56*
*20040108	 3.00	   9.00	   0.33*
*20040112	 9.00	   9.00	   1.00*
*20040115	 9.00	   9.00	   1.00*

Re: help in SUM

Former Member — Wed, 21 May 2008 14:25:58 GMT

better do a loop and add the field in to the required variable

Re: help in SUM

JozsefSzikszai — Wed, 21 May 2008 14:26:04 GMT

hi Ricardo,

one way is:

LOOP AT itab.

cnt = cnt + itab-c_hr.

ENDLOOP.

hope this helps

Re: help in SUM

Former Member — Wed, 21 May 2008 14:26:52 GMT

Hi,

Try this.

Loop at <int.table> into <work area>.

cnt = cnt + <work area>-c_hr.

clear <work area>.

endloop.

After this, you will have the sum in one variable cnt.

Re: help in SUM

Former Member — Wed, 21 May 2008 14:28:08 GMT

an option is:

data: count like i_t-c_hr.

clear count.

loop at i_t.

count = count + c_hr.

endloop.

or u can use the command COLLECT check with sap help..

Re: help in SUM

Former Member — Wed, 21 May 2008 14:30:58 GMT

Hello,


CLEAR cnt
LOOP AT itab INTO line.
  cnt = line-c_hr + cnt.
ENDLOOP.

Regards,

Re: help in SUM

former_member182354 — Wed, 21 May 2008 14:33:14 GMT

Hi,

Use collect statement....

Lop at itab.

.......

collect itab.

endloop.

Raghav