topic Re: average function in ALV Report in Application Development and Automation Discussions

average function in ALV Report

Former Member — Tue, 05 Aug 2008 03:21:30 GMT

Hi ,

I am doing Subtotal in ALV by Grouping the Fields. Instead of Using Subtotal i want to Use Average of

(Total / Quantity) in AlV. Is there any function availabile for doing Average in ALV Reports.

Point will be definately awarded .\

Kamal

Former Member — Tue, 05 Aug 2008 03:26:51 GMT

Hi Kamal,

Please check this link

Best regards,

raam

Former Member — Tue, 05 Aug 2008 03:32:09 GMT

> I am doing Subtotal in ALV by Grouping the Fields. Instead of Using Subtotal i want to Use Average of

> (Total / Quantity) in AlV. Is there any function availabile for doing Average in ALV Reports.

It is possible to show the Average using the FIELDCATALOG-DO_SUM = 'C'. for the column/field which you want the Average.



FIELDCATALOG-DO_SUM = 'C'. "<-----Avergage

Read the Rules , Don't use Forbidden words...

Former Member — Tue, 05 Aug 2008 03:52:46 GMT

Hi,

fieldcatlog-do_sum = 'C'.

It will solve ur issue....

Thanks.

Former Member — Tue, 05 Aug 2008 10:54:57 GMT

hi friends,

i don't want to use average (Mean values) but i want to divide Total Amount / total quantity. that is the

division of total amount by total quantity in subtotals.

Can anybody tell the code.

Kamal