AVG - time (based on group band condition)

[brjohnsmith]

Hi,

I used the DateDiff to get the difference between two time, however, I need to get the average of this time based on the count that I have on group band. for numeric value, if I just divide the numbers by count(), I get the average, but I cannot do it with the time format. please it seems that I need to convert it before to numberic, divide to the Count function (average), and only then to convert to time again. I am not sure if it is this way, but if someone knows how to solve it, I would appreciate it a lot. thx.

[Lech Kulikowski]

Hello,

Please check the following expression:
{TimeSpan.FromMinutes( AvgD( DateDiff(Date1,Date2).TotalMinutes) )}

Thank you.

[brjohnsmith]

Hi Lech, it worked, thx a lot.

[Andrew]

You are welcome!