Median function not working properly

[fuhrj]

Using build 2011.1

I have a report that groups by department. In the group footer, it shows the total service time for each department. Total service time is Start - Completed in minutes.

I am trying to get the median of the total time for each department, but the result comes out nowhere near the correct value.

In the group footer, I have a textbox with the following:

{Median(DateDiff(ReportData.timeComplete, ReportData.timeStart).Minutes)}

My datasource contains four row, and when calculated with DateDiff, produces these results:

8, 3, 1, 6 (displayed in the data band)

The median value should be 4.5 (3+6/2) but the report shows 7.

I can't determine where it's coming up with that number.

[Alex K.]

Hello,

Thank you for the bug report.
Please check the next prerelease build when it will be available.


Thank you.