Skip to Content
0
Former Member
Apr 23, 2009 at 10:32 AM

ALV average calculation without zero values

239 Views

Hi Experts,

I am using the ALV grid for report output, able to get the average values and it's working fine.

User wants the average calculation only for non-zero values, meaning...

1st row = 50.00

2nd row = 20.00

3rd row = 0.00

4th row = 40.00

5th row = 0.00

In this case current output is '110.00 / 5 = 22. it's working fine.

User requriement is 110 / 3 = 36.67. Is this functionallity possible in ALV ?.

Let me know your valueable suggestion.

Thanks

Raj