Filemaker TH325Z/A Fiche technique télécharger pdf (Page 151)

Chapter 9

Number functions 151

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.

SetPrecision

Format

SetPrecision(expression;precision)

1 2 ... 146 147 148 149 150 151 152 153 154 155 156 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 151