Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 11.3   11.4   11.5   12.0   12.1   12.2   12.3   12.4   12.5   13.0    Statistic    FMM    Blog  


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


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


Returns number or error.


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.


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

Blog Entries

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

MarkDown.ReleaseAll - Math.BitwiseAND

Feedback: Report problem or ask question.

Start Chat