I'm using Crystal For Enterprise and I have a SQL Server db as my data source. I've created a loss analysis report that's grouped by year and goes back 6 years. It only shows complete years. so it ranges from 2009 to 2014. Each year has total claim loss dollars and a count of total loss claims in the group footer(columns have different dollar amounts ex 0-1000, 1001-2500, etc). The client wants to show an average number of claim dollars and average claim count in the report footer per column, but they do not want to count years that do not have any loss claims. So the question is, how do I only count years that have loss claims in them to calculate the correct average??