Averages with Formula Fields

[carla]

Hello,

I have a formula {@daystoclose} which calculates the number of days to resolve a Technical Support case:

CDate({SW_CASE.swDateResolved}) - CDate({SW_CASE.swDateCreated}))

All of my closed cases are group by {@month}:
DatePart ("m", {SW_CASE.swDateResolved}) & "/" & DatePart ("yyyy", {SW_CASE.swDateResolved})

I am trying to figure out the average number of days between the Case Opened date and the Case Closed Date per month.

Nothing I am trying seems to be giving me accurate data. Can anyone help point me in the right direction?

I appreciate any help!
Carla

 

[kenhamady]

Put the {@daystoclose} on the detail band, highlight it and use menu options "Insert - Summary". Select the operation Average, and the group field for Month. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)