Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating the Median using Datediff

Status
Not open for further replies.
ftwiudan

ftwiudan

Programmer
Jan 20, 2012
4
0
0
US
I am trying to calculate the median using the datediff value of two dates. When I am trying to use the median function against the datediff formula, I get the error message stating that this field cannot be summarized.

I am getting the value of the datefiff in a report footer 3 (Section is suppressed), and trying to calculate the median in Footer 2b (Change in Month Group) and Footer 1 (Department ID).

I was using an array in calculating the median, but I got a error message stating the array dimension must be between 1 and 1000, so I am trying to use the median function.

Any help would be appreciated.
 
Status
Not open for further replies.

Similar threads

POrlowski
  • Locked
  • Question
Calculating Sick Time
Replies
7
Views
105
POrlowski
POrlowski
mmck1964
  • Question
Using "OR" to select data
Replies
4
Views
177
mmck1964
mmck1964
DennisY
  • Locked
  • Question
A subscript must be between 1 and the size of the array.
Replies
10
Views
123
DennisY
DennisY
ms901Boss
  • Locked
  • Question
Crystal Report with DateDiff 1
Replies
5
Views
131
ms901Boss
ms901Boss
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
66
socalvelo
socalvelo

Part and Inventory Search

Sponsor

Back
Top