Avg

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I wish to construct a formula that will give me the average yield only in
cases where the yield was not Null. The one below counts all enteries
including those with Nil yield.

=Avg([Settlement Yield])

Should it be something like :
=IF((Settlement Yield]) Is Not Null,=Avg([Settlement Yield]),Null))

Thank You
 
Bruce said:
I wish to construct a formula that will give me the average yield only in
cases where the yield was not Null. The one below counts all enteries
including those with Nil yield.

=Avg([Settlement Yield])

Should it be something like :
=IF((Settlement Yield]) Is Not Null,=Avg([Settlement Yield]),Null))
Click to expand...


You must have something other than Null in the records you
don't want to count. All the aggregate functions ignore
Null values.
 
Back
Top