topic Re: alv do_sum issue in Application Development and Automation Discussions

alv do_sum issue

Former Member — Thu, 27 Nov 2014 04:10:33 GMT

Dear all,

in my alv output, 3rd column = ( 2nd column / 1st column ) * 100.

this formula is not working for total row i.e i need (20/523) * 100 = 3.82

if i give do_sum = 'X' , then 3rd column total is 100.

if i give do_sum = 'C' then 3rd column value is 6.25.

how to apply the same formula for total column also?.

Waiting for the reply,

Thanks,

Dhivya N.

Re: alv do_sum issue

former_member210770 — Thu, 27 Nov 2014 04:59:39 GMT

Hi Dhivya,

I recommended not to write explicit coding for Total . Please use SAP Sum button in alv toolbar on alv display screen . Please Save your layout with this functionality and make it global layout.

So each and every time you will run this report you will get grand total at the end. No need to write coding for Sum and sub sum functionality.

Don't forgot to take your layout in Transport request in which your report is exist . You can use standard program to take layout of any report in Transport request.

Hope this will work.

Regards,

Sagar.

Re: alv do_sum issue

VijayaKrishnaG — Thu, 27 Nov 2014 05:10:58 GMT

Hi Dhivya,

Better don't use DO_SUM, you just write a code and calculate the total sum of those required columns and then append that as last row to your output internal table. Then you can add a color (as total) to the last row.

And apply same formula as you required before appending the row.

Regards,

Vijay

Re: alv do_sum issue

Former Member — Thu, 27 Nov 2014 05:51:48 GMT

Thanks vijaykrishna gudala.