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.5
12.0
12.1
12.2
12.3
12.4
12.5
13.0
13.1
13.2
Statistic
FMM
Blog
Component: Math
Math functions.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 2.2 / 12.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
| Item | Details |
|---|---|
| Math.Average Calculates average of given values. | All 12.1 |
| Math.BitwiseAND Perform bitwise AND operation. | All 4.1 |
| Math.BitwiseNOT Perform bitwise not operation. | All 4.1 |
| Math.BitwiseOR Perform bitwise or operation. | All 4.1 |
| Math.BitwiseShiftLeft Perform bitwise shift left. | All 4.1 |
| Math.BitwiseShiftRight Perform bitwise shift right. | All 4.1 |
| Math.BitwiseXOR Perform bitwise xor operation. | All 4.1 |
| Math.DecToHex Converts a number to a hexadecimal number. | All 2.5 |
| Math.DecodeNumber Decodes a number from it's binary representation. | All 6.4 |
| Math.EncodeNumber Encodes a number as binary data as hex text. | All 6.4 |
| Math.FormatNumber Formats a number. | All 11.1 |
| Math.HexToDec Converts a hexadecimal number to a normal decimal number. | All 2.5 |
| Math.InchToPixel Converts a inch value to pixel. | All 3.4 |
| Math.InsidePolygon Deprecated Checks if one point is inside a polygon. | All 2.2 |
| Math.IsValidCC Verifies a credit card number. | All 3.1 |
| Math.Max Calculates maximum of given values. | All 12.1 |
| Math.Median Calculates median of given values. | All 12.1 |
| Math.MillimeterToPixel Converts a millimeter value to pixel. | All 3.4 |
| Math.Min Calculates minimum of given values. | All 12.1 |
| Math.Multiply Multiplies values. | All 12.1 |
| Math.NormInv Calculates NormInv function like in Excel. | All 11.1 |
| Math.NumberToText Converts a number value to a text string. | All 2.9 |
| Math.PixelToInch Converts a pixel value to inch. | All 3.4 |
| Math.PixelToMillimeter Converts a pixel value to millimeter. | All 3.4 |
| Math.PolylineDecode Decodes number from Polyline Algorithm Format. | All 9.2 |
| Math.PolylineEncode Encodes number in Polyline Algorithm Format. | All 9.2 |
| Math.Reciprocal Calculates reciprocals of values. | All 12.1 |
| Math.StandardDeviation Calculates standard deviation of given values. | All 12.1 |
| Math.Sum Calculates sum of given values. | All 12.1 |
| Math.TextToNumber Converts a text to a number. | All 2.9 |
30 functions shown.
These functions are free to use.
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.
- Version 11.3
- Fixed a problem with a math function, which affected time zone calculation for EmailParser.SentDate, EmailParser.ReceiveDate and Time.TimeStampToUTC functions (broken in v11.2).
- Version 11.1
- Added Math.FormatNumber function.
- Added Math.NormInv function.
- Fixed problem in Math.FormatNumber with missing zero before decimal separator for small number.
- Version 9.2
- Added Math.PolylineEncode and Math.PolylineDecode functions for Google's Encoded Polyline Algorithm Format.
- Version 7.3
- Fixed a bug with Math.InsidePolygon.
- Improved Math.BitwiseAND, Math.BitwiseOR, Math.BitwiseNOT, Math.BitwiseXOR, Math.BitwiseShiftRight and Math.BitwiseShiftLeft to use 64-bit integers instead of 32-bit.
Blog Entries
- New in MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin, version 12.1pr1
- MBS FileMaker Plugin, version 11.3pr2
- MBS FileMaker Plugin, version 11.1pr8
FileMaker Magazin
Example Databases
