Logo
  • Submit a request
  • Sign in
  • Home
  • What's New
    1. Sigma Computing
    2. Function Index
    3. Math Functions

RoundUp

Rounds a number up to the specified number of digits.

Usage

RoundUp(number, [digits])

number (required) The number to be rounded.

digits [optional] The number of decimal places to which to round.
If "digits" value is negative, the function will return an integer with that many least-significant digits zeroed (see example 4 below).

 

Example

(1) Returns 3.15

RoundUp(3.141, 2)

(2) Returns -3.14.

RoundUp(-3.141, 2)

(3) Rounds the value for each row in the input column up. Numbers are rounded by 2 digits.

RoundUp([Cost], 2)

Screen_Shot_2020-12-01_at_10.07.04_AM.png

(4) Rounds the input number up and replaces its last 2 digits with 0s.  A negative "digits" value returns an integer with that many least-significant digits zeroed. 

RoundUp([Cost], -2)

Screen_Shot_2020-12-01_at_10.08.18_AM.png

 

See Also

Ceiling - Rounds the input number up to the closest multiple of equal or greater value.

Round - Rounds the input number to the specified number of digits.

RoundDown - Rounds a number down to the specified number of digits.

MRound - Rounds the input number to the closest multiple of the given factor.

Floor - Rounds the input number up to the closest multiple of equal or lesser value. 

 

 

We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.

© Sigma Computing
Links
  • Sigma Home
  • About Us
  • Start Your Free Trial
  • Contact Us
Support
  • Documentation
  • Function Index
Contacts
  • support@sigmacomputing.com