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 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.