ROUND
Rounds a number to a specified number of decimal places to ensure consistent precision in calculations.
Last updated
Was this helpful?
Rounds a number to a specified number of decimal places to ensure consistent precision in calculations.
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 desired precision. This function is commonly used in financial calculations, reporting, and data formatting where consistent decimal accuracy is required.
ROUND(value, significance)value - The number to be rounded (Required).
significance - The decimal places to which the number should be rounded. If this argument is missing, it is considered as 1 (Optional).
ROUND(COLUMN1, 1)In the example below, the ROUND measure is created using the ROUND function, which rounds the values in MEASURE 2 to the specified number of decimal places.

Last updated
Was this helpful?
Was this helpful?