RoundDown

Rounds a number down to the specified number of digits Category: math Syntax:

RoundDown([number], [digits])

Returns: Number Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`number`	`number or column`	✓ Yes	The number to be rounded
`digits`	`number`	✗ No	The number of decimal places to which to round. If not provided, defaults to 0

Allowed Column Types for number: INT, FLOAT, DECIMAL

RoundDown([Cost], 2)

Rounds the value for each row in the Cost column down by 2 digits

RoundDown(3.141, 2)

Returns 3.14 Result: 3.14

RoundDown([Cost], -2)

Rounds the input number down and replaces its last 2 digits with 0s

Last modified on March 6, 2026