Category: Number

Syntax: truncate ( number; precision )


numberAny expression that resolves to a numeric value.

precisionAny expression that resolves to a numeric value.

Data type returned: Number


Returns the specified number truncated to the specified number of decimal places (precision). Unlike the Round() function, the TRuncate() function simply discards further digits without performing any sort of rounding.

Truncating a number by using a precision parameter of 0 has the same effect as taking the Int() of that number. truncate (x; 0) = Int (x).

Negative values can be used for the precision parameter in the truncate() function. For instance, TRuncate (1234.1234; -1) returns 1230. truncate (1234.1234; -2) returns 1200.




truncate (Pi; 6)

Returns 3.141592.

truncate (Amount; 2)

Returns 54.65 when Amount contains 54.651259.

truncate (1234.1234; 0)

Returns 1234.

truncate (-1234.1234; 0)

Returns 1234.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: