| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Math.Average
Calculates average of given values.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Math | 12.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Math.Average"; 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 average 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 FileMaker's math functions, so very precise in results.
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
Calculates average of numbers in two lists:
MBS( "Math.Average"; "1¶6¶4"; "7¶8" )
Example result: 5.2
Calculate average of 3 values:
MBS( "Math.Average"; 3; 4; 8 )
Example result: 5
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
