Description
The ROUND function rounds a number to the nearest integer or to the nearest specified multiple.
Note: The rounding mode is 'half-even' (also known as a 'banker's round'), thus if the number is exactly midway between two numbers (i.e. 2.5) then it will round it to the nearest even number.
Usage
This function is used to round a number to the nearest integer or a specified multiple.
Syntax:ROUND(number, [multiple])
Examples
-
Round a Number to the Nearest Integer:
ROUND(LATEST(#[Actions].[Number]))Rounds the latest value in the Number column of the Actions table to the nearest integer.
-
Round the Result of a Calculation:
ROUND(#[Calculation])Rounds the result of the Calculation attribute to the nearest integer.
Inputs
| Argument | Data Type | Description |
|---|---|---|
| number | Number | The number to round. |
| [multiple] | Number | (Optional) The multiple to which to round. |
Returns
Type: Number
- Produces the rounded value based on the specified number and optional multiple.