Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Average Using Group Counts

Status
Not open for further replies.

mwake

Programmer
Feb 12, 2004
151
US
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??

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top