urgent? - not that easy

[#1]

looking for an avg function which ignores 0s

eg. if teama teamcount=3, teamb teamcount=5, teamc teamcount=0 then avg???(teamcount) should return 4 not 2.666...

[swuehl]

Try

=avg( if( teamcount<>0, teamcount) )

Hope this helps,

Stefan

[#3]

Using Set Analysis instead:

=avg({<teamcount={"<>0"}>} teamcount)

[#4]

thanks for the help

[#5]

thanks for your help