topic Re: ALV tree -average in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319976#M509178 <HTML><HEAD></HEAD><BODY><P>In the 'end_of_list' event of the ALV you can calculate the avarage and display. </P><P>Ex: </P><P></P><P></P><P> </P><PRE><CODE>call function 'REUSE_ALV_GRID_DISPLAY' exporting i_callback_program = gd_repid i_callback_top_of_page = 'TOP-OF-PAGE' i_callback_html_end_of_list = 'END_OF_LIST_HTML' is_layout = gd_layout it_fieldcat = fieldcatalog[] i_save = 'X' tables t_outtab = it_ekko exceptions program_error = 1 others = 2.</CODE></PRE><P></P><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><P>*&amp; Form end_of_list_html</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> output at the end of the list - not in printed output *</P></LI></UL><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><P></P><PRE><CODE>FORM end_of_list_html USING end TYPE REF TO cl_dd_document. calculate the avarage and display. ENDFORM. "end_of_list_html.</CODE></PRE><P></P></BODY></HTML> Mon, 28 May 2007 10:30:06 GMT Former Member 2007-05-28T10:30:06Z ALV tree -average https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319974#M509176 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>i am doing a alv tree display. in which i want to display the average amount .but i find only do_sum. is there any possiblity to do average.</P><P>thanks,</P><P>madhu</P></BODY></HTML> Mon, 28 May 2007 10:27:13 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319974#M509176 Former Member 2007-05-28T10:27:13Z Re: ALV tree -average https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319975#M509177 <HTML><HEAD></HEAD><BODY><P>give </P><P></P><PRE><CODE>wa_fcat-DO_SUM = 'C'. " to get average</CODE></PRE><P></P></BODY></HTML> Mon, 28 May 2007 10:28:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319975#M509177 Former Member 2007-05-28T10:28:38Z Re: ALV tree -average https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319976#M509178 <HTML><HEAD></HEAD><BODY><P>In the 'end_of_list' event of the ALV you can calculate the avarage and display. </P><P>Ex: </P><P></P><P></P><P> </P><PRE><CODE>call function 'REUSE_ALV_GRID_DISPLAY' exporting i_callback_program = gd_repid i_callback_top_of_page = 'TOP-OF-PAGE' i_callback_html_end_of_list = 'END_OF_LIST_HTML' is_layout = gd_layout it_fieldcat = fieldcatalog[] i_save = 'X' tables t_outtab = it_ekko exceptions program_error = 1 others = 2.</CODE></PRE><P></P><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><P>*&amp; Form end_of_list_html</P><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><UL><LI level="1" type="ul"><P> output at the end of the list - not in printed output *</P></LI></UL><P><STRONG>&amp;----</STRONG></P><HR originaltext="-------------------------------------------------------------" /><P></P><P></P><PRE><CODE>FORM end_of_list_html USING end TYPE REF TO cl_dd_document. calculate the avarage and display. ENDFORM. "end_of_list_html.</CODE></PRE><P></P></BODY></HTML> Mon, 28 May 2007 10:30:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/alv-tree-average/m-p/2319976#M509178 Former Member 2007-05-28T10:30:06Z