ALV Calculate Average

[Former Member]

Hi all,

I have an ALV report (REUSE_ALV_HIERSEQ_LIST_DISPLAY) in which the last line is a sum of one field. However, there is another field where I want to get the average, not the sum. Is there a way to do it?

Thanks a lot.

Fabio

[Former Member]

Hi all,

I have an ALV report (REUSE_ALV_HIERSEQ_LIST_DISPLAY) in which the last line is a sum of one field. However, there is another field where I want to get the average, not the sum. Is there a way to do it?

Thanks a lot.

Fabio

[Former Member]

Hi Fabrio,

For calculating the averages, you have to set the

DO_SUM = 'C' instead of 'X' in the field catalog for that column.

Regards,

Ravi

[Former Member]

It works for REUSE_ALV_GRID_DISPLAY, but not for REUSE_ALV_HIERSEQ_LIST_DISPLAY. Any clues?

null

[Former Member]

Any other option ?

Thanks

[Former Member]

set the field H_FTYPE to 'AVG' and the field DO_SUM to 'X'.

Zazáááá