RDL - Understanding the Round function

Question

Hi, What does the "3" in the following RDL code mean: ROUND(durationMetricvalue / 1000000, 3) AS responseTime? I am trying to understand the function and its meaning. Thanks in advance

Answer 1

Hi @Sutheswaran, Suwhathi,

ROUND ( numeric_expression , length)

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category.

length

Is the precision to which numeric_expression is to be rounded. length must be an expression of type tinyint, smallint, or int. When length is a positive number, numeric_expression is rounded to the number of decimal positions specified by length. When length is a negative number, numeric_expression is rounded on the left side of the decimal point, as specified by length. So the "3" means rounded to the number(3) of decimal positions. Regards， Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I believe the documentation you're looking for his here. As discussed there the first argument is the value to round. The second argument is the # of digits after the decimal. So given the value of 3 the value will be rounded to the thousandths (3 places). Example: 1234.56789 would round to 1234.568. Note that rounding rules are an optional third argument if you want to use different rules.