SetPrecision()

SetPrecision()

Category: Number

Syntax: SetPrecision ( expression ; precision )

Parameters: expression ”any number or expression that returns a number; precision ”an integer from 1 to 400.

Description: FileMaker normally computes decimals with 16 digits of precision. The SetPrecision() function allows you to specify with up to 400 digits of precision.

The expression specified in the first parameter is rounded at the digit specified by the second parameter.

Examples:

 SetPrecision(Pi;28) 

Returns 3.1415926535897932384626433833 .

 SetPrecision(Pi;29) 

Returns 3.14159265358979323846264338328 .

Comments:

The trigonometric functions do not support extended precision.

You can specify a number below 17 as the precision, but FileMaker still returns 16 digits of precision regardless. Use the Round() function instead to specify a precision up to 16.