median value for a set of records single value.
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
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.?