Calculating the median

[pteaxwa]

I was asked to calculate some median values and was surprised that as of Filemaker 6 (version I use - not sure about 7) has no built in function to calculate the median value of a found set.

Hopefully this file can be of use to someone who needs to do the same. Also, if something is incorrect in the script, I would appreciate some feedback!

median.zip

[pteaxwa]

I realized that in that file I forgot to ensure the calculation is unstored. It needs to be updated depending on the "current found count".

Attached is the slightly modified version.

median.zip