topic Re: Get Average using Subtotal Value in ALV in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346609#M1639637 <HTML><HEAD></HEAD><BODY><P>Thanks Sharin! now it's giving the correct figure...</P><P></P><P>regards,</P><P>bernadette</P></BODY></HTML> Tue, 06 Dec 2011 04:49:51 GMT Former Member 2011-12-06T04:49:51Z Get Average using Subtotal Value in ALV https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346607#M1639635 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>i have a question. is it possible to get the average using the value in subtotal field in ALV OO.</P><P></P><P>example:</P><P>Total Value GL Price Amount GL Price %</P><P>1 2 50</P><P>2 6 33.33 </P><P>3 8 37.5</P><P>subtotal: 6 subtotal: 16 subtotal: 37.5 </P><P></P><P>GL Price % Sub total computatiom:</P><P></P><P> = 6 / 16 * 100</P><P> = 37.5</P><P></P><P>i already used ls_fcat-do_sum = 'C'. but it's giving me a wrong figure.</P><P></P><P>please help...</P><P></P><P>Thank You.</P></BODY></HTML> Tue, 06 Dec 2011 03:17:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346607#M1639635 Former Member 2011-12-06T03:17:42Z Re: Get Average using Subtotal Value in ALV https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346608#M1639636 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try using 'SORT' .</P><P></P><P>Sort the table to indicate on which level average has to be done. This enables 'ls_fcat-do_sum = 'C' to work correctly.</P><P></P><P></P><P>Regards,</P><P>Sharin</P></BODY></HTML> Tue, 06 Dec 2011 04:41:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346608#M1639636 Former Member 2011-12-06T04:41:56Z Re: Get Average using Subtotal Value in ALV https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346609#M1639637 <HTML><HEAD></HEAD><BODY><P>Thanks Sharin! now it's giving the correct figure...</P><P></P><P>regards,</P><P>bernadette</P></BODY></HTML> Tue, 06 Dec 2011 04:49:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346609#M1639637 Former Member 2011-12-06T04:49:51Z Re: Get Average using Subtotal Value in ALV https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346610#M1639638 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use the below threads to solve your issue.</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="831088"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="538122"></A></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="992103"></A></P><P></P><P>Regards,</P><P>Saravana.S</P></BODY></HTML> Tue, 06 Dec 2011 04:49:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-average-using-subtotal-value-in-alv/m-p/8346610#M1639638 Former Member 2011-12-06T04:49:55Z