Hello Guys,
Please check out below tips for excluding the zero from the SSRS Expression.
=Avg(IIF(Field!FieldName.Value ="0", Nothing,Field!FieldName.Value))
Above expression is also works for the SUM, MIN, MAX and etc..
if you have any query feel free write on the comment.
Please check out below tips for excluding the zero from the SSRS Expression.
=Avg(IIF(Field!FieldName.Value ="0", Nothing,Field!FieldName.Value))
Above expression is also works for the SUM, MIN, MAX and etc..
if you have any query feel free write on the comment.