Skip to main content
Rounds a number up to the specified number of digits Category: math Syntax:
Returns: Number Context Filtering: ✓ Yes

Parameters

Allowed Column Types for number: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 1
  • Maximum parameters: 2

Examples

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