topic Re: alv % total in Application Development and Automation Discussions

alv % total

Former Member — Tue, 14 Dec 2004 20:27:47 GMT

hi all,

i have a field , field , field in alv grid .

field3 = ( field1 / field2 ) * 100 .

i need to display the field3 sum ???? any thoughts ??

Re: alv % total

Former Member — Tue, 14 Dec 2004 20:32:02 GMT

What would you like to do? Should the end-user be able to perform the calculation or do want to program it in your ABAP?

Regards,

Dick Krijger

Re: alv % total

Former Member — Tue, 14 Dec 2004 20:43:10 GMT

i can calculate the avg in abap , i do not know how to modify the results line ??

anyways when i set the display-totals , the sum should be displayed ..???

Re: alv % total

Former Member — Wed, 15 Dec 2004 04:00:10 GMT

Hi Shiv,

I have certain questions, if you can answer, them probably the picture might get clearer.

a) When you click on the sum(sigma) button, for column field3, are you getting a total, or are you getting a message in the status bar saying "Totals available only for integer values".

b) What is type of field3 ? Have you specified any type for field3 ? Have you use the <b>INTTYPE</b> or <b>DATATYPE</b> fields for that entry of fieldcatalog(field3) ?

For grid related issues, there is an excellent tutorial available from Serdar. You may refer that.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/an easy reference for alv grid control.pdf

Regards,

Subramanian V.

Re: alv % total

Former Member — Wed, 15 Dec 2004 14:34:56 GMT

i made that field as char, so that i can display totals ,

if i hit sum , it will literally diplays SUM(in which case it's wrong..coz my sum is sum/no of rows(avg)..as i said i can calculate the avg in abap ,but how to display it in grid ??

when you hit sum , end of the report ...i want to modify the final Line(display line--yellow line). i tried EVENT BEFORE_LINE_OUTPUT ,for some reason it's not working...any help will be greatly appreciated.

Regards,

shiv

Re: alv % total

Former Member — Wed, 15 Dec 2004 14:37:27 GMT

sorry i said CHAR, but it's a CURR field

Shiv.

Re: alv % total

Former Member — Wed, 15 Dec 2004 14:47:33 GMT

Hi Shiv,

What you have to do is in the field catalog set DO_SUM to 'X' for the field3 and for others set it as blank. This will solve your problem.

Before you are calling the output before that you can do the calculation.

In case if you want to use BEFORE_LINE_OUTPUT. There are function modules that you have to call for refreshing the same at the output screen.

REUSE_ALV_GRID_LAYOUT_INFO_SET - For Grid

REUSE_ALV_LIST_LAYOUT_INFO_SET - For List

But I doubt if you will be able to use BEFORE_LINE_OUTPUT event with GRID display.

regards,

Satya

Re: alv % total

Former Member — Wed, 15 Dec 2004 19:05:22 GMT

I have the same problem in one of my ALV reports. I also calculate a percentage ((field1/field2) * 100) and show this field on each row. However, my sub-total value cannot just be summed up like suggested but needs to be calculated on sub-total and grand-total level again. Thus, the do_sum nor the Sigma icon would work.

Further is there an option on sub-total and grand-total level that allows me to average the field values?

Just for your information all my fields are type p with 2 decimals

Re: alv % total

Former Member — Fri, 25 Feb 2005 06:29:39 GMT

Hi Abap Gurus,

in my catalog i hv marked field with do_sum = 'x'.

But then also i dont get total in alv display.

Wht shld be the data types of field, if v want to show its total in ALV. My fields has type Curr 15...

Suggestion are welcome....

Re: alv % total

Former Member — Thu, 01 Jun 2006 11:37:00 GMT

Hi, can you put your code here, i'll try to find something wrong, ok?