Functions Reference

146 FileMaker Functions Reference
SetPrecision
Format
SetPrecision(expression;precision)
Parameters
expression - any numeric expression
precision - any number or numeric expression
Data type returned
number
Description
Computes any math functions contained within expression that support extended
precision to precision decimal places (up to 400). All functions except the trigonometric
functions support extended precision. This function doesn’t perform a truncation: constant
numbers are left at the precision in which they were entered.
Examples
SetPrecision(5/9;30) returns 0.555555555555555555555555555556.
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.
Sign
Format
Sign(number)
Parameter
number - any numeric expression or field containing a numeric expression
Data type returned
number
Description
Returns one of three possible values: -1 when number is negative, 0 when it’s zero, and
1 when it’s positive.