  # Change Nickname

Current Nickname:

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File

# round()

Function `round()` calculates the nearest value of a given number, corrected to a designated position of digit; when two nearest values are found, returns the one with larger absolute value.

Arguments：

• Number <number>
• Position of digit <integer>，-1 for '10', 0 (default) for '1', 1 for '0.1', and so on

Returns：

• Round <number>

## Common Usage

Example: Direct calculate

``````uncollect [-3.75, 7.55] as a
uncollect [0, 1] as b
return table(a, b, round(a, b))
``````

``````|  a    | b | round(a, b) |
|-------|---|-------------|
| -3.75 | 0 | -4          |
| 7.55  | 1 | 7.6         |
``````

Example: Multiply and calculate

``````uncollect [-3.75, 7.55] as a
uncollect [0, 1] as b
with round(a, b) as c
return table(a, b, c)
``````

``````|  a    | b |   c  |
|-------|---|------|
| -3.75 | 0 | -4   |
| -3.75 | 1 | -3.8 |
| 7.55  | 0 | 8    |
| 7.55  | 1 | 7.6  |
``````