topic Re: summing up fields in Application Development and Automation Discussions

summing up fields

Former Member — Thu, 12 Jun 2008 05:26:52 GMT

Hi guys,

i have data like this:

data1 data2 data3

1001(type c) 2 2568 (type c)

1001(type c) 3 2569 (type c)

For every same entry in data1, i have to sum the correponding data in data2. how can it be done?

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:28:15 GMT

use add-corresponding

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:29:04 GMT

u can either use collect statement or control break statements like AT END OF...ENDAT.

Re: summing up fields

kesavadas_thekkillath — Thu, 12 Jun 2008 05:32:16 GMT

loop at itab.

at new field1.

sum.

write itab-field1.

write itab-field2.

endat.

endloop.

Re: summing up fields

pranav_nagpal2 — Thu, 12 Jun 2008 05:35:11 GMT

Hi,

Use collect statement it will be do.

Thanks.

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:35:16 GMT

hi prashant,

PS that collect wont work properly as there are two fields of type c.

anything else??

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:45:49 GMT

hi there

i had gone through a similar problem.collect will not work for your case since there are 2 non-numeric fields...

the foll worked for me...

loop at itab.

at new itab-field1.

sum = 0.

break.

endat.

sum = sum + itab-field2.

write 😕 sum.

endloop.

everytime the field1 value changes, the loop breaks and control goes to loop-at command. this way, for same field1 values, sum will get calculated and stored in sum.

i hope it helps...

reward if helpful

regards

niharika

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:52:19 GMT

Hi Prem..

use at-new .... endat with the field name(Data1) and take a temp variable to calculate the DATA2.

Hope this info will work.

Reward Points if helpful

Regards

Karan

Re: summing up fields

Former Member — Thu, 12 Jun 2008 05:55:06 GMT

thanks all....

query solved.... points rewarded to helpful ans...

Re: summing up fields

pranav_nagpal2 — Thu, 12 Jun 2008 06:02:50 GMT

Hi Prem,

First sort internal table by data1 field.

Using

sort itab by data1.

then use this code.

loop at itab.

at new itab-data1.

sum = 0.

break.

endat.

sum = sum + itab-data2.

write 😕 sum.

endloop.