The ROUNDDOWN function rounds a number down toward zero to a specified number of decimal places. Unlike standard rounding, the function always reduces the value regardless of the digit that follows. It is commonly used in financial and reporting calculations where conservative estimates or controlled rounding are required.
ROUNDDOWN(value, significance)value: The number to round.significance (Optional): The number of decimal places to round to.Returns the number rounded down toward zero.
ROUNDDOWN(Total Sales, 2)In this example, the Rounded Sales measure is created using the ROUNDDOWN function, which rounds the values in Total Sales down toward zero to two decimal places.
