Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
Math.Median
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
Parameters
Parameter | Description | Example |
---|---|---|
Values... | Pass an argument for each value or list of values. | 123 |
Result
Returns number or error.
Description
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.
Examples
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
- Version 12.1
- Added math functions: Math.Average, Math.Max, Math.Median, Math.Min, Math.Multiply, Math.Reciprocal, Math.StandardDeviation, and Math.Sum.
Blog Entries
- New in MBS FileMaker Plugin 12.1
- Neues MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin 12.1 - More than 6700 Functions In One Plugin
- MBS FileMaker Plugin, version 12.1pr1
This function is free to use.
Created 28th January 2022, last changed 30th January 2023