Number Functions

Number functions allow various mathematical expressions within FileMaker.

Table 5.8. Number Functions

Syntax	Data Type Returned
Abs ( number )	Number, Time
Ceiling ( number )	Number
Combination ( setSize; numberOfChoices )	Number
Div ( number; divisor )	Number
Exp ( number )	Number
Factorial ( number {; numberOfFactors })	Number
Floor ( number )	Number
Int ( number )	Number
Lg ( number )	Number
Ln ( number )	Number
Log ( number )	Number
Mod ( number; divisor )	Number
Random	Number
Round ( number; precision )	Number
SetPrecision ( expression; precision )	Number
Sign ( number )	Number
Sqrt ( number )	Number
truncate ( number; precision )	Number