Functions Reference

Chapter 9
|
Number functions 145
Data type returned
number
Description
Returns a random number between zero and one. 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.
Example
NumDice + NumSides * Random
Round
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
Description
Returns number rounded off to the specified precision (number of decimal places). 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.
Round(123.456;-1) returns 120.