Functions Reference

142 FileMaker Functions Reference
Int
Format
Int(number)
Parameter
number - any numeric expression or field containing a numeric expression
Data type returned
number
Description
Returns the whole number (integer) part of number without rounding. It drops any digits
to the right of the decimal point, depending on the number you specify.
Examples
Int(1.45) returns 1.
Int(123.987) returns 123.
Int(Players/3) returns 4, if Players contains 13.
Lg
Format
Lg(number)
Parameter
number - any numeric expression
or field containing a numeric expression
Data type returned
number
Description
Returns the base 2 logarithm of number, which can be any positive value. Negative
values return an error. For 0, the Lg function returns nothing because these values are
out of the acceptable range.
Examples
Lg(1) = 0
Lg(2) = 1
Lg(32) = 5
Λγ
Λν νυμβερ()
Λν 2()
------------------------------=