topic Function for Average in Application Development and Automation Discussions

Function for Average

Former Member — Mon, 09 Feb 2009 14:04:26 GMT

Hai Friends,

We can get subtotal from SET_SORTS and SET_AGGREGATIONS.

I want to get the average like subtotals. Is there any function for this.

Material     Date               Quantity

A              01-01-2009         20
                03-01-2009         10
                04-01-2009         30
-----------------------------------------------------
                                         20
-----------------------------------------------------
B             05-01-2009          100
               06-01-2009            50
----------------------------------------------------
                                           75
-----------------------------------------------------

Re: Function for Average

Former Member — Tue, 10 Feb 2009 05:53:23 GMT

hi,

you can use..........AT END OF MATERIAL

SUM.

-RICK

Re: Function for Average

Former Member — Wed, 11 Feb 2009 07:10:32 GMT

Hi,

If you want your output in ALV format then you have to make use of DO_SUM= 'X' and SUB_TOTAL = 'X',

and if you want your outout in classical report then you have to make use of statements AT END OF and then SUM of your Quantity field.

Hope it helps

Regrds

Mansi

Re: Function for Average

Former Member — Thu, 12 Feb 2009 08:24:24 GMT

Hi,



1. Just use :

ls_fieldcat-do_sum = 'C'.


(use 'C', and not 'X')

Thanks

Arun