ROUNDUP

Rounds a number up, away from zero, to a specified number of decimal places for higher or conservative estimates.

The ROUNDUP function rounds a number up, away from zero, to a specified number of decimal places. It always increases the value regardless of the following digits and is useful in scenarios where higher estimates or safety margins are required.

Syntax

ROUNDUP(value, significance)

Arguments

value - The number to be rounded (Required).

significance - The number of decimal places to round off (Optional).

Example

ROUNDUP(Actuals,2) //Rounds the Actuals to 2 decimal places

In the example below, the ROUNDUP measure is created using the ROUNDUP function, which rounds the Actuals values up, away from zero, to two decimal places.

Applying ROUNDUP Function