Discussion board where members can get started with QlikView.
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...
=avg( if( teamcount<>0, teamcount) )
Hope this helps,
Using Set Analysis instead:
thanks for the help
thanks for your help