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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date summary problem

Status
Not open for further replies.

Dmarious

Programmer
Apr 10, 2001
19
0
0
IL
Hi,

I have a database with a record for every hour in a year (or more), with the field sales. I have three groups : first for every year, second for every month ad third for every day. I can manage without the third group.

I'm trying to show the average sales per day for each month, but I can't for some reason do it.

I'm using CR 8.0

Tanks Dmarious
 
Subtotal (Sum) the sales for each month.
Count the days for that mont.
Add a formula that divides the Sum by the count. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top