Functions Reference

FILEMAKER FUNCTIONS REFERENCE 197
Description
Returns a pseudo-random number in the range (0,1). FileMaker Pro generates a new random
number when you:
• insert the Random function into a formula
• cause a formula containing the Random function to be reevaluated (by changing data in any
of the fields the formula uses)
• display or access a calculation field defined to have an unstored result
Examples
NumDice + NumSides * Random
Related topics
Contents
Functions reference (alphabetical list)
Round
Purpose
Returns number rounded off to the specified precision (number of decimal places).
Format
Round(number;precision)
Parameters
number - any numeric expression or field containing a numeric expression
precision - any numeric expression or field containing a numeric expression
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
If you round a negative number of decimal places, all digits to the right of the decimal point are
dropped, and the number is rounded to the nearest tens, hundreds, and so on. The
Round function
always rounds up at 0.5.
Examples
Round(123.456;2) returns 123.46.
Round(14.5;0) returns 15.
Round(29343.98;-3) returns 29000.