Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old


Calculates median of given values.

Component Version macOS Windows Linux Server iOS SDK
Math 12.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Math.Median"; Values... )   More


Parameter Description Example
Values... Pass an argument for each value or list of values. 123


Returns number or error.


Calculates median of given values.
Takes values from arguments, which may be list of values or single values.
Returns empty result if no values are passed.

Uses double values, so you may see rounding to about 15 digits.

This function takes variable number of parameters. Pass as much parameters as needed separated by the semicolon in FileMaker.
Please repeat Values parameter as often as you need.


Find median for a list of value:

MBS( "Math.Median"; "1¶5¶4¶7¶9" )

Find median in list with median, so we get average between 5 and 7:

MBS( "Math.Median"; "1¶5¶4¶7¶9¶0" )

Example result: 6

Release notes

Blog Entries

This function is free to use.

Created 28th January 2022, last changed 30th January 2023

Math.Max - Math.MillimeterToPixel