topic Re: average in alv grid display in Application Development and Automation Discussions

average in alv grid display

Former Member — Tue, 14 Nov 2006 09:39:42 GMT

hi,

how to calculate avegarge in alv.

for example for one purchase order there are five line items with differnt netprice.

how to calculate average of this purcahse order.

remember in alv grid display

regards,

Sunil.k

Re: average in alv grid display

Former Member — Tue, 14 Nov 2006 09:43:33 GMT

In filling up the field catalog you should mention

fieldcat-do_sum = 'C'.

Regards,

ravi

Re: average in alv grid display

Former Member — Tue, 14 Nov 2006 09:44:23 GMT

Hi,

u need to populate sort table like this

lt_sort-spos = 1.

lt_sort-fieldname = 'EBELN'.

lt_sort-subtot = 'X'.

When ever there is change in PO it give the subtotal to ur price field.

Madhavi

Re: average in alv grid display

Former Member — Tue, 14 Nov 2006 09:47:05 GMT

You can do this in ALV object model using CL_SALV_TABLE's GET_AGGREGATIONS method.

In REUSE_ALV_GRID_DISPLAY,you have to do it through code.Insert a row in the ALV internal table on change of the purchase order.This way you will have an average row for every po.