When calculating the average value, its ignoring the zero values.
For ex: to calculate the average of 10,20,30,0,0 it is calculating as 60/3 instead of 60/5.
Can anyone pls let me know what should be the issue in SSRS
I have given it as
and tried with different conversions in CDec area.