Number Functions
Number functions allow various mathematical expressions within FileMaker.
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 |