Average Count

[#1]

I am trying to find the average using count for the following

Count({<TERM_CODE_EFF={'2012-13'},COLLEGE_CODE={'AF','BF','HF','SF'},[No Attendance]={'X'}>}[No Attendance])/Count(Total{<TERM_CODE_EFF={'2012-13'},COLLEGE_CODE={'AF','BF','HF','SF'},[No Attendance]={'X'}>}[No Attendance])

However I am not gettign the result I expect though I have used thsi tryp of Set Analysis sucessfully in the past

[Gysbert_Wassenaar · Accepted solution]

Your expression returns only one number, not an average. Try something like avg(aggr( myexpressionhere, mydim1, mydim2) and replace myexpressionhere with your expression and mydim1,mydim2 with the dimensions of your chart.

[#3]

That worked a treat thank you