I have a field that calculates the number of days between when a help ticket is submitted and when the first response goes out to it
If(first_response_date>0; first_response_date - report_date;If(zcClosedText = "Closed";close_date - report_date; "No 1st Response Yet"))
I then tried creating a summary field to average these days. But I get the dreaded "?" on some, but not all, displays in the summary report. I am wondering what may be causing it. If it is the text in some of the calculation fields, is there a way around it?