Formula (Extended): $TRUNC Function
Overview¶
Return the value with the decimal part of the numeric value truncated to the specified number of digits.
Syntax¶
Parameters¶
| Parameter | Type | Required | Description |
|---|---|---|---|
| Numeric value | Half-width numeric value | Required | Numeric value to truncate the decimal part. |
| [Number of digits] | Half-width numeric value | Optional | Specify the number of digits after truncation. If omitted, 0 is assumed. |
Column Usable as Parameters¶
| Parameter | Classification | Numeric Value | Date | Description | Check |
|---|---|---|---|---|---|
| Numeric value | Yes | Yes | No | Yes | No |
| [Number of digits] | Yes | Yes | No | Yes | No |
Return Value¶
A numeric value with the decimal point truncated to the specified number of digits.
Return Value Display Content¶
| Target | Display Content of Return Value |
|---|---|
| Classification (including title, status, manager, owner) | Display return value. In the case of a drop-down list with values, the options that match the return value are displayed. |
| Numeric Value (including work volume, progression rate, remaining work volume) | Display return value. |
| Date (including start and completion) | Do not display. |
| Description (including content) | Display return value. |
| Check (including lock) | Do not display. |
Usage Example ①¶
Specify the parameter by the screen column name (name displayed)
Formula¶
Parameters¶
Calculation Result¶
Usage Example ②¶
Specify the parameter [Number of digits]
Formula¶
Parameters¶
Calculation Result¶
