AnsweredAssumed Answered

I have a field that calculates the number of days between when a help ticket is submitted and when...

Question asked by gregdc on Nov 18, 2014
Latest reply on Nov 18, 2014 by philmodjunk

Post

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?  

 

Outcomes