U.M. (Windows)

C-4 FileMaker Pro User’s Guide
Number functions
Trim (text) Returns text without leading and trailing spaces
Upper (text) Converts text to uppercase
WordCount (text) Returns the number of words in text
Choose FileMaker Help Index from the Help menu, and then type:
E text functions
Syntax Definition
Abs (number) Returns the absolute value of number
Exp (number) Returns the value of e raised to the power of number
Int (number) Returns the integer (whole) portion of number
Mod (number, divisor) Returns the remainder after number is divided by
divisor
NumToText (number) Converts number to text
Random For each record, returns a random number between 0.0
and 1.0
Round (number, precision) Returns number rounded to the number of decimal
places in precision. When precision is negative, all
digits right of the decimal separator are dropped and
number is rounded to the nearest ten for a precision
of -1, the nearest hundred for -2, and so on.
Sign (number) Returns –1 when number is negative; returns 0 when
number is zero; returns 1 when number is positive
Sqrt (number) Returns the square root of number
Truncate (number, precision) Returns number truncated to the number of decimal
places in precision
Choose FileMaker Help Index from the Help menu, and then type:
E number functions
Syntax Definition
?
?