I need to find the average interval from the Assignment date to Completed date. Criteria of conditions of status code: Completed, Service Coodinator of William, Order type of New.
William Completed 17-Feb-10 New 3/1/2010
William Completed 17-Feb-10 New 3/5/2010
William Completed 17-Feb-10 New 4/2/2010
William Completed 16-Feb-10 Old 2/19/2010
William Completed 16-Feb-10 New 2/19/2010
Susan Completed 16-Feb-10 New 2/19/2010
William Completed 16-Feb-10 New 2/19/2010
William Completed 16-Feb-10 New 2/19/2010
William Completed 16-Feb-10 New 2/19/2010
Bookmarks