calculating median

[sirtemplar]

hi again. may someone help me translate the following calculation o have from excel.

=MEDIAN(D2:D51,G2:G51)

i am trying to get the median. i get it in excel but not in filemaker. d2:51 are the values on the D field and g2:g51 on another. thanks

[mr_vodka]

There is not a "natural" function for calculating the median with FM.

Here are some threads pertaining to it. Also I know that you dont have FM Avdanced, but it may be worth the investment to use Custom Functions. some of the methods here make use of custom functions.

Median thread 1

Median Thread 2

Median CF

[comment]

You don't need a custom function to calculate the median - provided your values are sorted. If they're not, then you DO need a custom function to sort them.

I think the first step here would be to normalize the database, so that the values are in the same field for all records. After that - it depends on whether we want the median of the found set, or of related records, or of all records.

Edited May 4, 2007 by Guest

[sirtemplar]

dear folks,

i have been trying for days finding the median but i am still at the dark. i am enclosing the file i have now in case someone would like to help me find the median of the formeur & noFfr (last two fields on the database) thanks.

:

median.zip

[Raybaudi]

Hi

this is a scripted way ( it returns the median of the found set )

median.zip