Median function not working properly
Posted: Fri Apr 08, 2011 1:37 pm
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.
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.