| 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 / 14.0 | ✅ 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.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.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 |
33 functions shown.
These functions are free to use.
Release notes
- 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).
- 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
- 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
