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 |