Skip to content

ROUNDDOWN

A number rounded towards zero to a number of decimals.

Group: Math. Compatible with DAX.

Syntax

ROUNDDOWN ( <number>, <num_digits> )

Parameter	Type	Description
`number`	Number	The number that goes down, towards zero.
`num_digits`	Whole number	How many decimals to keep: 0 for a whole number, a negative number for tens, hundreds and so on.

Returns

Number. The number rounded towards zero to that many decimals.

Remarks

Towards zero means that a negative number goes up in value: ROUNDDOWN ( -3.789, 1 ) is -3.7. FLOOR and INT go towards minus infinity instead.
ROUNDDOWN ( number, 0 ) is the same as TRUNC ( number ).
A blank gives BLANK.

Examples

Down, towards zero

EVALUATE
ROW (
    "3.789 to 1", ROUNDDOWN ( 3.789, 1 ),
    "-3.789 to 1", ROUNDDOWN ( -3.789, 1 ),
    "1289 to -2", ROUNDDOWN ( 1289, -2 ),
    "3.789 to 0", ROUNDDOWN ( 3.789, 0 )
)

3.789 to 1	-3.789 to 1	1289 to -2	3.789 to 0
3.7	-3.7	1200	3

ROUND, ROUNDUP, TRUNC, FLOOR, INT.

Last updated 3 November 2026 · OpenBI Studio 0.3.74