calculating an average

[#1]

Hi

I am trying to calculate the average processing time based on the difference between datetimeprocessed and datetimereceived.. But I only want to calculate the average for rows where there is a value in datetimeprocessed field.

I am trying to use the following expression to achieve this:

=sum(Interval(DateTimeProcessed-DateTimeReceived))/$Rows

I am not sure if the above is correct. Can someone please help me with getting the correct expression.

Thanks

[hic]

Avg(DateTimeProcessed-DateTimeReceived) should work. Or you can use

Sum(DateTimeProcessed-DateTimeReceived)/Count(DateTimeProcessed-DateTimeReceived)

In both cases, DateTimeProcessed-DateTimeReceived is evaluated to NULL when one of the fields is missing, and will then not be included.

HIC

[#3]

Hi Henric

Your suggested solution works perfectly.

Thanks