| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Component: Math
Math functions.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 2.2 / 15.3 | ✅ 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.BitwiseRotate Rotates the bits in a 64-bit integer number. | All 15.3 |
| 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.ClearBit Clears a bit in a 64-bit number. | All 15.3 |
| 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.GetBit Queries a bit in a 64-bit number. | All 15.3 |
| 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.MovingAverage Calculates moving average. | All 14.2 |
| 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.Random.ExponentialDistribution Generates a random number using exponential distribution. | All 14.0 |
| Math.Random.NormalDistribution Generates a random number using normal distribution. | All 14.0 |
| Math.Random.PoissonDistribution Generates a random number using poisson distribution. | All 14.0 |
| Math.Rate Returns the interest rate per period of an annuity. | All 14.5 |
| Math.Reciprocal Calculates reciprocals of values. | All 12.1 |
| Math.SetBit Sets a bit in a 64-bit number. | All 15.3 |
| 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 |
39 functions shown.
Release notes
- Version 16.0
- Added exponential2 as mode to Math.MovingAverage function.
- Version 15.4
- Fixed Math.BitwiseRotate to better rotate to right.
- Version 15.3
- Added Math.BitwiseRotate function.
- Added Math.SetBit, Math.ClearBit and Math.GetBit functions.
- Version 15.0
- Improved Math.FormatNumber function to work better with 11 or more digits.
- Version 14.5
- Added Math.Rate function.
- Version 14.2
- Added Math.MovingAverage function.
- Version 14.0
- Added Math.Random.ExponentialDistribution, Math.Random.NormalDistribution and Math.Random.PoissonDistribution functions.
- 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).
Blog Entries
- MBS FileMaker Plugin 15.3 News
- MBS @ FMTraining.TV - The Claris FileMaker MonkeyBread Plug-in 14.0 Release
- New in MBS FileMaker Plugin 14.0
- 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