ROUNDDOWN

Rounds a number down toward zero to a specified number of decimal places for controlled or conservative calculations.

The ROUNDDOWN function rounds a number down toward zero to a specified number of decimal places. It always reduces the value regardless of the digit that follows and is useful in scenarios where conservative estimates are required.

Syntax

ROUNDDOWN(value, significance)

Arguments

value -The number to be rounded (Required).

significance - The number of decimal places to round off (Optional).

Example

ROUNDDOWN(Actuals,2) //Rounds the Actuals to 1 decimal place

In the example below, the ROUNDDOWN measure is created using the ROUNDDOWN function, which rounds the Actuals values down toward zero to one decimal place.

Applying ROUNDDOWN Function