average in the report

[azhar2006]

Hello all
I'm trying to get the result (average) in a column in the report
And put something like this
But tell me that there are arguments and the like
= IIf (([C2] = 0), 0, ([C2]) / (IIf ([C2]) = 0,0,1)))

[June7]

Why are you using IIf that will return division by 0? Division by 0 is not possible.

That expression does not average anything. The image shows C3 in the expression but your typed version does not.

If you want to exclude zeros from average, since nulls are ignored, try:

=Avg(IIf([C2]=0, Null, [C2])

[ssanfu]

There are too many parenthesis and they are in the wrong places
Try

= IIf([C2] = 0, 0, [C2] / IIf([C2] = 0, 0, 1))

I hope this isn't the real expression... it doesn't make any sense.

[azhar2006]

Thank you very much June7 and ssanfu