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

Avg Business days

Status
Not open for further replies.

RunnerDan

IS-IT--Management
Joined
Jul 16, 2002
Messages
9
Location
US
I used Ken Hamaday's formula to find the business days between two dates, works great! But, I need to find the average of my records. What's the easiest way?
 
Sum({KensFormula}) / Count({Database.Field})
 
Make sure that you start my formula with "WhileReadingRecords" or you won't be able to Sum that formula. If you had to use "WhilePrintingRecords" you will need to use the 3-formula technique to sum the formula. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB
tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top