Reference > Functions reference > Number functions > SetPrecision
 

SetPrecision

Computes any math function with a precision of 16 to 400 digits to the right of the decimal point.

Format 

SetPrecision(expression;precision)

Parameters 

expression - any numeric expression

precision - any number or numeric expression for the number of decimal places

Data type returned 

number

Originated in 

FileMaker Pro 7.0

Description 

All functions except trigonometric functions support extended precision. This function doesn’t perform a truncation.

Example 1 

SetPrecision(5/9;30) returns 0.555555555555555555555555555556.

SetPrecision(1.321321321321321321321321321;0) returns 1.3213213213213213.

Example 2 

SetPrecision(If(field1>5;Exp(50);Average(5/9;1/7;5/7));25) returns either

5184705528587072464087.4533229334853848274691006 if field1 > 5, or

0.4708994708994708994708995 if field1 <= 5.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas