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.2 ✅ 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   New in 14.2
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.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

34 functions shown.

These functions are free to use.

Release notes

Blog Entries

FileMaker Magazin

Example Databases