Trunc function
Applies to: TBM Studio 12.0 and later
Truncates a real number to an integer by removing the fractional part of the number.
Where to use
This function can be used in:
- Data sets
- Calculated metrics and reports with metric columns
- Formula columns in report tables
- Dynamic text
Syntax
Trunc(value)
Arguments
value
A real number to be truncated.
Return type
Number
Examples
| Example function | Return value |
|---|---|
| =Trunc(1.23) | 1 |
| =Trunc(1.985) | 1 |
See also: Round