Get Average using Subtotal Value in ALV

[Former Member]

Hi experts,

i have a question. is it possible to get the average using the value in subtotal field in ALV OO.

example:

Total Value GL Price Amount GL Price %

1 2 50

2 6 33.33

3 8 37.5

subtotal: 6 subtotal: 16 subtotal: 37.5

GL Price % Sub total computatiom:

= 6 / 16 * 100

= 37.5

i already used ls_fcat-do_sum = 'C'. but it's giving me a wrong figure.

please help...

Thank You.

[Former Member]

Hi,

Try using 'SORT' .

Sort the table to indicate on which level average has to be done. This enables 'ls_fcat-do_sum = 'C' to work correctly.

Regards,

Sharin

[Former Member]

Thanks Sharin! now it's giving the correct figure...

regards,

bernadette

[Former Member]

Hi,

Use the below threads to solve your issue.

Regards,

Saravana.S