Reference > Functions reference > Number functions > Truncate
 

Truncate

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.

Example 1 

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