$round (aggregation)¶

Definition定义¶

$round¶

New in version 4.2..

$round rounds a number to a whole integer or to a specified decimal place.将数字舍入为整数或指定的小数点。

$round has the following syntax:语法如下所示：

{ $round : [ <number>, <place> ] }

Field字段	Type类型	Description描述
<number>	number	Can be any valid expression that resolves to a number. 可以是解析为数字的任何有效表达式。Specifically, the expression must resolve to an integer, double, decimal, or long.具体来说，表达式必须解析为整数、双精度、十进制或长整型。 $round returns an error if the expression resolves to a non-numeric data type.如果表达式解析为非数字数据类型，$round将返回错误。
<place>	integer	Optional. 可选。Can be any valid expression that resolves to an integer between -20 and 100, exclusive. e.g. -20 < place < 100. 可以是解析为-20到100（排除）之间的整数的任何有效表达式，亦-20 < place < 100。Defaults to 0 if unspecified.如果未指定，则默认为0。 If <place> resolves to a positive integer, $round rounds to <place> decimal places.如果<place>解析为正整数，$round舍入为<place>小数位。 For example, $round : [1234.5678, 2] rounds to two decimal places and returns 1234.57.例如，$round : [1234.5678, 2]舍入到小数点后两位，返回1234.57。 If <place> resolves to a negative integer, $round rounds using the digit <place> to the left of the decimal.如果<place>解析为负整数，则使用小数点左侧的数字<place>进行舍入。 For example, $round : [1234.5678, -2] uses the 2nd digit to the left of the decimal (3) and returns 1200.例如，$round : [1234.5678, -2]使用小数点左边的第二位数字（3）并返回1200。 If the absolute value of <place> equals or exceeds the number of digits to the left of the decimal, $round returns 0.如果<place>的绝对值等于或超过小数点左边的位数，$round返回0。 For example, $round : [ 1234.5678, -4] specifies the fourth digit to the left of the decimal. 例如，$round : [ 1234.5678, -4]指定小数点左边的第四位数字。This equals the number of digits left of the decimal and returns 0.这等于小数点左边的位数，返回0。 If <place> resolves to 0, $round rounds using the first digit to the right of the decimal and returns rounded integer value.如果<place>解析为0，$round使用小数点右边的第一个数字进行舍入，并返回舍入整数值。 For example, $round : [1234.5678, 0] returns 1234.例如，$round : [1234.5678, 0]返回1234。

Behavior行为¶

Example示例¶

A collection named samples contains the following documents:名为samples的集合包含以下文档：

{ _id: 1, value: 19.25 }
{ _id: 2, value: 28.73 }
{ _id: 3, value: 34.32 }
{ _id: 4, value: -45.39 }

• The following aggregation returns value rounded to the first decimal place:以下聚合返回四舍五入到第一个小数位的value：

  db.samples.aggregate([
     { $project: { roundedValue: { $round: [ "$value", 1 ] } } }
  ])

  The operation returns the following results:操作返回以下结果：

  { "_id" : 1, "roundedValue" : 19.2 }
  { "_id" : 2, "roundedValue" : 28.7 }
  { "_id" : 3, "roundedValue" : 34.3 }
  { "_id" : 4, "roundedValue" : -45.4 }

• The following aggregation returns value rounded using the first digit to the left of the decimal:以下聚合返回使用小数点左边第一个数字取整的value：

  db.samples.aggregate([
     { $project: { roundedValue: { $round: [ "$value", -1 ] } } }
  ])

  The operation returns the following results:操作返回以下结果：

  { "_id" : 1, "roundedValue" : 10 }
  { "_id" : 2, "roundedValue" : 20 }
  { "_id" : 3, "roundedValue" : 30 }
  { "_id" : 4, "roundedValue" : -50 }

• The following aggregation returns value rounded to the whole integer:以下聚合返回四舍五入为整数的value：

  db.samples.aggregate([
     { $project: { roundedValue: { $round: [ "$value", 0 ] } } }
  ])

  The operation returns the following results:操作返回以下结果：

  { "_id" : 1, "roundedValue" : 19 }
  { "_id" : 2, "roundedValue" : 29 }
  { "_id" : 3, "roundedValue" : 34 }
  { "_id" : 4, "roundedValue" : -45 }