Current Position:Home > Average sum in an Alv grid

Average sum in an Alv grid

Update:10-11Source: network consolidation
Advertisement
I have a problem with the sum on a column.
if i use:
  <i>ls_fieldcat-do_sum      = 'X'.</i>
i get a sum (the values added to eachother)
but what i really want is the sum as an average of the rows in that column.
How do i solve this. Do i need to add my own logic or is there a funcionality for this.
Best Regards
Claes
Message was edited by: Claes Widestadh
Message was edited by: Claes Widestadh

The Best Answer

Advertisement
Hi Claes,
1. Im finding how to do with code :
2. In the mean time,
   using screen we can do like this :
3. Show the alv list on screen first :
4. EDIT ---> Calculate ---> Mean Value
regards,
amit  m.
  • Average sum in an Alv grid Update:10-11

    I have a problem with the sum on a column. if i use:   <i>ls_fieldcat-do_sum      = 'X'.</i> i get a sum (the values added to eachother) but what i really want is the sum as an average of the rows in that column. How do i solve this. Do i need

  • Display of "Average Values Text in ALV grid" Update:11-30

    Hi     I use ALV grid to display  the fields from a table. I have 15 columns.  I need to do average for four columns. In the field catalog i did a do_sum for those fields.    When the ALV grid is displayed I get average values for these columns. Eg.

  • Dump when summing up CURR field in ALV GRID display Update:10-11

    Hi All, I am getting dump when I try to sum the CURR field in my ALV Grid Display. The field is of CURR 23.  I am using classes and methods to display alv grid. I tried passing <fs_fieldcat>-do_sum = 'X'. When I did this, it is dumping without even

  • SUM from ALV grid Update:10-11

    Hey all, What i have to enable the sum button on the alv grid ... i guess from application bar....it is sign of sum... please give me option what i have to do.... points will be rewarded.....hi, there will be sign like E (total ) using this u can hav

  • Average value for a Date Field in an OO Alv Grid. Update:10-11

    Hi Abapers. I've been searching for some info about averages in OO Alv grid lists but cannot find an answer to what I'm really need. The question is that, for getting an average, a 'C' value must be set in the field DO_SUM of the fieldcatalog structu

  • Average sum for a column in ALV tree layout Update:10-11

    Hi, I've trying to set an average sum for a column in an ALV tree report.  In the field catalog i set the DO_SUM field to 'X' and this will do a total sum, but I can't find out how in the code to do the average sum. Also to get round this I was going

  • Sum in ALV grid Update:11-30

    hi guys, i have an internal table BEGIN OF itab,         hkont    TYPE bseg-hkont,         dmbtr    TYPE bseg-dmbtr,         int_amt1 TYPE bseg-dmbtr,         int_amt2 TYPE bseg-dmbtr,         int_amt3 TYPE bseg-dmbtr,         int_amt4 TYPE bseg-dmbt

  • How can we sum for the field on alv grid Update:11-30

    Dear Freinds,                I am having the field count .....in the ouput (iam using alv grid) .......which dispalys  the id's which are identical . i have scneario similar to the below in my ALV Output ID                count         total 4000    

  • Custom tool bar for sorting and summing in alv grid Update:11-30

    what is the function module to use the tool bar in the alv output screen which has - summing , sorting and other button above the alv grid control.It is part of the class CL_GUI_ALV_GRID. Have a look at this class, especially the methods within this

  • Alv grid - displaying average value Update:11-30

    Please use a more informative subject in future.  This time I've changed it for you. Hi, i want to get the average value in a field using ALV GRID.can anybody help me on this. Edited by: Matt on Mar 30, 2009 9:45 AMTYPES :   BEGIN OF ty_vbak,     vko