Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A User Manual

expression - any numeric 

precision - any number or numeric expression

number

Computes any math 

 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: 

 

numbers are left at the precision in which they were entered.

SetPrecision(5/9;30) returns 

.

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

either

 if field1 > 

, or

 if field1 <= 

.

Sign(number)

number - any numeric 

 or 

number

Returns one of three possible values: 

 when number is negative, 

 when it’s zero, and 

 when it’s positive.

Sign(15.12) returns 

.

Sign(-175) returns 

.

Sign(BalanceDue) returns 

, if BalanceDue is a number field containing 

.