FunctionCopy link to clipboard
trunc( value, numberOfDecimals )
Truncates a decimal number to the specified number of places after the decimal point.
ParametersCopy link to clipboard
| Keyword | Type | Description |
|---|---|---|
|
|
Decimal |
A decimal number. |
|
|
Number |
The number of places after the decimal point to which the number should be truncated. |
ReturnsCopy link to clipboard
Decimal
Usage considerationsCopy link to clipboard
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.
ExamplesCopy link to clipboard
trunc(7.3675,2) returns 7.36
Feature compatibilityCopy link to clipboard
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 |