ALV average calculation without zero values
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.