Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Try
=avg( if( teamcount<>0, teamcount) )
Hope this helps,
Stefan
Using Set Analysis instead:
=avg({<teamcount={"<>0"}>} teamcount)
thanks for the help
thanks for your help