Truncate
Purpose
Returns a number truncated to the specified number of decimal places.
Format
Truncate(number;precision)
Parameters
number - any numeric
expression or
field containing a numeric expression
precision - any numeric expression or field containing a numeric expression for the number of decimal places
Data type returned
number
Originated in
FileMaker Pro 6.0 or earlier
Description
This function doesn’t evaluate digits beyond the specified precision. Use the Round function to round up or down to the required precision.
Examples
Truncate(123.456;2) returns 123.45.
Truncate(-14.6;0) returns -14.
Truncate(29343.98;-3) returns 29000.
Truncate(123.456;4) returns 123.456.
Truncate(29343.98;5) returns 29343.98.
Related topics