The ROUND function rounds a number to a specified number of decimal places. It adjusts the value based on standard rounding rules to produce a result with the required precision. This function is commonly used in financial calculations, reporting, and data formatting where consistent decimal accuracy is required.
Syntax
ROUND(value,significance)
Arguments
value: The number to round.
significance (Optional): The number of decimal places to which the value should be rounded. If not specified, the default value is 1.
Return value
Returns the rounded value with the specified precision.
Example
ROUND(TotalSales,2)
In the example below, the Rounded Sales measure is created using the ROUND function, which rounds the values in Total Sales to 2 decimal places.
