Free cookie consent management tool by TermsFeed trunc() Function
trunc() Function


trunc( value, numberOfDecimals )

Truncates a decimal number to the specified number of places after the decimal point.


Keyword Type Description



A decimal number.



The number of places after the decimal point to which the number should be truncated.



Usage considerations

If the numberOfDecimals parameter is not specified, a default value of 0 is used and the decimal number is truncated to just its integer value.

Appian stores the Number (Decimal) data type as a double precision floating-point decimal, which is a 64-bit IEEE 754 floating point. You may experience unexpected results when using this function due to a limitation with the IEEE 754 standard. Refer to Appian Knowledge Base article #1426 for more details and suggested workarounds.


trunc(7.3675,2) returns 7.36

Feature compatibility

The table below lists this function's compatibility with various features in Appian.
Feature Compatibility Note
Portals Compatible
Offline Mobile Compatible
Sync-Time Custom Record Fields Compatible

Can be used to create a custom record field that only evaluates at sync time.

Real-Time Custom Record Fields Incompatible

Custom record fields that evaluate in real time must be configured using one or more Custom Field functions.

Process Reports Compatible
Process Events Compatible

trunc() Function