3 Replies Latest reply on Nov 18, 2014 1:43 PM by philmodjunk

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

    gregdc

      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?