trunc( value, numberOfDecimals )
Truncates a decimal number to the specified number of places after the decimal point.
Keyword | Type | Description |
---|---|---|
|
Decimal |
A decimal number. |
|
Number |
The number of places after the decimal point to which the number should be truncated. |
Decimal
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 | 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