Skip to Content
avatar image
Former Member

problem in alv

HI FRIENDS ,

I m creating ALV grid report. in that

i have to get the following output.

no problem with value 1 field.

1. but value 2 field should be common for both 2 records. i cannot use sort option because i have to find subtotal of value 2. if i use sort option then value 2 records (2419.46 +2419.46) will get added .that is wrong.

2. next difference = value2 - value1. but it should be displayed with subtotal output.not as actual record..

how to do this .. if u know pls let me know..

thanks and regards,

kani.

VALUE 1 VALUE 2 DIFF

1200.73

1200.73 2419.46

2400.46 2419.46 19 SUBTOTAL

12

12 28

24 28 4 SUBTOTAL

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 04, 2008 at 12:02 PM

    case 1 and case2 will be possible with the help of SUBTOTAL_TEXT event. inside the event you can modify the SUBTOTAL values.

    For case1 there is direct solution , if the value repeats then you can take the average of that.

    for Getting the average you can use the DO_SUM option in the fieldcatalog level.

    FCAT-DO_SUM = 'C'. "<----This calculates the Average,

    Add comment
    10|10000 characters needed characters exceeded