AnsweredAssumed Answered

median value for a set of records single value.

Question asked by capnahab on Feb 7, 2012
Latest reply on Feb 7, 2012 by raybaudi

Title

median value for a set of records single value.

Post

I need to find the median length of stay (los) of hospital patients. I have the data for los in a field for all patients. I can create a summary field for average but the agreed best marker is median.

I am pretty new to filemaker but have found this 

http://www.briandunning.com/cf/298

I am not sure how to implement it as a custom function. I understand how to sort the records into ascending los.

is this the way to go , or is there a simpler way.?

Outcomes