Skip to main content
Rounds a number up to the specified number of digits Category: math Syntax:
RoundUp([number], [digits])
Returns: Number Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
numbernumber or column✓ YesThe number to be rounded
digitsnumber✗ NoThe number of decimal places to which to round. If not provided, defaults to 0
Allowed Column Types for number: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

Examples

RoundUp([Cost], 2)
Rounds the value for each row in the Cost column up by 2 digits
RoundUp(3.141, 2)
Returns 3.15 Result: 3.15
RoundUp([Cost], -2)
Rounds the input number up and replaces its last 2 digits with 0s
Last modified on March 13, 2026