Filemaker Pro 8.5 Advanced Maintenance TG761Z/A User Manual

Chapter 9

  

|

  Number functions     153

Sqrt(number)

number - any positive number, numeric 

, or 

expression.

number

Calculates the square root of number.

Sqrt(4) returns 

.

Sqrt(SquareFeet) returns 

 if the SquareFeet number field contains 

.

Truncate(number;precision)

number - any numeric 

 or 

precision - any numeric expression or field containing a numeric expression

number

Returns number truncated to the specified precision (number of decimal places), 

without evaluating the value of discarded digits. Use the Round function to round up or 

down to the required precision.

Truncate(123.456;2) returns 

.

Truncate(-14.6;0) returns 

.

Sqrt

number

=