Round()

Format

Round(Number [,Decimals])

Returns

Returns the rounded value of Number to the specified number of decimal places.

Notes: 

• Values below half way between rounded values are rounded down.
• Values above half way are rounded up.
• Values exactly equal to half way are also rounded up.
• Rounding up means away from zero.
• Rounding down means towards zero.

Inputs

Number: The number to be rounded.
Behaviour: Required
Dimension: Collection, SingleValue, MultiCollection
Valid data types: Decimal, Integer

Decimals: The number of decimal places to which to round, between 0 and 20. If a decimal is supplied, it is converted to an integer. Default: 0
Behaviour: Optional
Dimension: Collection, SingleValue
Valid data types: Decimal, Integer

How to format data types

Examples

Expression: Round(23.45)
Result: 23

Expression: Round(23.45,0)
Result: 23

Expression: Round(1.24, 1) 
Result: 1.2

Expression: Round(1.25, 1)
Result: 1.3

Expression: Round(1.26, 1)
Result: 1.3

Expression: Round(-1.24, 1)
Result: -1.2

Expression: Round(-1.25, 1)
Result: -1.3

Expression: Round(-1.26, 1)
Result: -1.3

Release History

• Round() 4.6.5
  • Changed Number parameter to support MultiCollection values.
• Round() 4.0
  • Initial version