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

Категории