The Round function is a built-in function that returns the decimal value n rounded to a specific number of fractional digits (by default, 0).

The return of the function depends on where it is used:

Where |
Round method |

Development environment |
Round half to even (rounds to the nearest integer, 0.5 rounds the number to the nearest even integer). |

(Aggregate) |
Round half away from 0 (rounds to the nearest integer, 0.5 rounds the number further away from 0). |

(Aggregate) |
Round half up (rounds to the nearest integer, 0.5 rounds up). |

Also, in an Aggregate expression there is no optional input parameter.

n: mandatory; Decimal Type.

The value to be rounded.

fractionalDigits: optional; Integer
Type.

Use it to specify the number of fractional digits that n has to be rounded
to. The default value is 0.

Decimal Type

Usage |
Round half to even |
Round half away from 0 |
Round half up |

Round(-10.89) |
-11 |
-11 |
-11 |

Round(-5.5) |
-6 |
-6 |
-5 |

Round(9.3) |
9 |
9 |
9 |

Round(2.5) |
2 |
3 |
3 |

Round(3.5) |
4 |
4 |
4 |

Round(9.123456789 , 5) |
9.12346 |
(not applicable) |
(not applicable) |

See Also

Trunc Function | Available Mathematical Functions | Available Built-in Functions