Monkeybread Software - MBS FileMaker Plugin: Component: Math

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.5	✅ 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.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 New in 14.5 Returns the interest rate per period of an annuity.	All 14.5
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

35 functions shown.

Release notes

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).
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.

Component: Math

Release notes

Blog Entries

FileMaker Magazin

Example Databases