Filemaker Pro 8.5 Educational Maintenance T2 TJ085LL/A Manual De Usuario
Los códigos de productos
TJ085LL/A
152 FileMaker Functions Reference
Parameters
expression - any numeric
precision - any number or numeric expression
Data type returned
number
Description
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.
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
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.
Examples
Sign(15.12) returns
1
.
Sign(-175) returns
-1
.
Sign(BalanceDue) returns
0
, if BalanceDue is a number field containing
0
.