topic Re: Sum in Application Development and Automation Discussions

Sum

Former Member — Tue, 24 Oct 2006 13:03:03 GMT

In OO alv display i am showing the 'quantity to be produced ' as per the day.

Now i need to sum up the quantity for each day.

how can i do it,

Re: Sum

Former Member — Tue, 24 Oct 2006 13:07:57 GMT

Hi John,

You have to include one more column for the date.

Fill the sort table for that field.

Make sure that the column for the date is the first field in the list.

Then apply the sort function on that field. Then you can get the quantity per day.

Regards,

ravi

Re: Sum

RichHeilman — Tue, 24 Oct 2006 13:09:40 GMT

You can set a sort on the day column. Use the "SORT" parameter in the SET_TABLE_FOR_FIRST_DISPLAY method. Five the field name for the "Day" column and set SUBTOTAL = 'X'. Make sure to set the qty field column as DO_SUM = 'X' in the field catalog.

Regards,

Rich Heilman

Re: Sum

Former Member — Tue, 24 Oct 2006 13:33:25 GMT

Hai Rich,

Thank u very much....

Its easier to understand, if u have sample code for this.

please send me.......

Re: Sum

Former Member — Tue, 24 Oct 2006 13:50:04 GMT

Hai Rich, i suppose this will not help in this case.

My display is like this

Monday ( Text)

planned (Text )

matnr

quantity

matnr

quantity

......

.....

....

......

sum :

______

I need to sum only the quantitiy here.....

How can i do it.