>Median is a value in a series of numbers where there are an equal number of values less than and greater than. Not knowing if there may be duplicate values makes this a bit harder. I'd try for the arithmetic mean (by getting the minimumand maximum values via CALCULATE) as a starting point. Where to go from there, I haven't figured out.:-)
You guys are making it too difficult :) It's just the (n+1)/2 value of an ordered list if odd # elements, or average of middle two values in the case of an even number of elements...Cetin is close, but no need to use array, I don't think...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.