Calculating Mean

[#1]

Hi,

Can somebody please help

YearMonth	Population	CM Tickets	Incident Rate
	2136	533	6.03	Average???
11-03	1050	286	3.27	3.02
11-04	1086	250	2.76	3.02

I have the following table in Qlikview Which calculates the inciden rate based on diving (CM Ticket/Population)*(12 for yearly figure.

I want to be able to have the average showing )which you can see should be 3.02). I can then change the straight table to a chart. I don't want to use the trendline feature here as I plan to calculate upper and lower control limits based on the average.

Please help??

Dave

[#2]

Pat,

Had to tweak it slightly but works a treat. This total function will enable me to do a few reports