Trunc(Input: Variant, Precision: Variant)
Input. Variable
Precision. The quantity of decimal places, to which the number should be truncated:
If Precision is greater than 0, the number is rounded to the specified number of decimal places after a decimal point
If Precision is equal to 0, the number is rounded to the nearest integer
If Precision is equal to 0, the number is rounded to the nearest integer.
It truncates variable points to the specified number of decimal places.
Formula | Result | Application |
= Trunc({Brazil|BCA},2) | Brazil|BCA factor observations are truncated to two decimal places. |
It can be used in formulas of calculated series of time series database and model formulas of modeling container that is a child of the time series database. |
= Trunc(X1,0) | X1 factor points are truncated to nearest integer. |
It can be used in model formulas of modeling container. |
= Trunc(5.978,1) | 5.9 |
It can be used in formulas of calculated series of time series database and modeling container models. |
See also:
Functions Available in Expression Editor │ Arithmetic Functions │ IModelling.Trunc