MongoDB $divide Operator

What is the $divide operator in MongoDB?

MongoDB provides a variety of arithmetic expression operators. The $divide operator is one of those operators. This operator is used in the aggregation pipeline stages. It is also used to divide one number by another and return the result.

Syntax of the $divide operator:

To use this operator, you have to pass the arguments in an array. In this operator, the first argument is a dividend, and the second argument is a divisor.

Examples:

In the following examples, we are working with:

Database: javaTpoint
Collection: products
Document: Ten documents that contain the details of each product

Output:

>db.products.find().pretty()
{
    {
        "_id" : 1,
        "name" : "Mobile",
        "totalPrice" : 100000,
        "totalQuantity" : 50,
        "billYear" : 2018
    }
    {
        "_id" : 2,
        "name" : "Keyboard",
        "totalPrice" : 5000,
        "totalQuantity" : 10,
        "billYear" : 2017
    }
    {
        "_id" : 3,
        "name" : "Mouse",
        "totalPrice" : 2000,
        "totalQuantity" : 5,
        "billYear" : 2018
    }
    {
        "_id" : 4,
        "name" : "Memory Card",
        "totalPrice" : 2500,
        "totalQuantity" : 25,
        "billYear" : 2019
    }
    {
        "_id" : 5,
        "name" : "Mobile",
        "totalPrice" : 20000,
        "totalQuantity" : 4,
        "billYear" : 2020
    }
    {
        "_id" : 6,
        "name" : "Mobile",
        "totalPrice" : 25000,
        "totalQuantity" : 2,
        "billYear" : 2021
    }
    {
        "_id" : 7,
        "name" : "Memory Card",
        "totalPrice" : 1000,
        "totalQuantity" : 10,
        "billYear" : 2019
    }
    {
        "_id" : 8,
        "name" : "Pen drive",
        "totalPrice" : 15000,
        "totalQuantity" : "Two",
        "billYear" : 2018
    }
    {
        "_id" : 9,
        "name" : "Laptop",
        "billDetail" : {
                               "totalPrice" : 45000,
                               "totalQuantity" : 1,
                              }
        "billYear" : 2021
    }
    {
        "_id" : 10,
        "name" : "Memory Carde",
        "totalPrice" : 4000,
        "totalQuantity" : 50,
        "billYear" : 2020
    }
}

Example 1: Using $divide operator

In this example, we are going to use the $divide operator to find the price of a mobile.

db.products.aggregate(
 [
   {$match: { name : "Mobile"}},
      {
          $project: 
              {
                name : 1,
                totalPrice : 1,
                totalQuantity : 1,
                mobilePrice : {$divide: ["$totalPrice", "$totalQuantity"]}
               }
      }
 ]
)

Output:

{
        "_id" : 1,
        "name" : "Mobile",
        "totalPrice" : 100000,
        "totalQuantity" : 50,
        "mobilePrice" : 2000
}
{
        "_id" : 5,
        "name" : "Mobile",
        "totalPrice" : 20000,
        "totalQuantity" : 4,
        "mobilePrice" : 5000
}
{
        "_id" : 6,
        "name" : "Mobile",
        "totalPrice" : 25000,
        "totalQuantity" : 2,
        "mobilePrice" : 12500
}

Example 2: Add your own number

If the user wants to divide a field by a certain number, the user can do so. In this example, we're going to divide the "totalPrice" field by 2.

db.products.aggregate(
 [
   {$match: { name : "Memory Card"}},
      {
          $project: 
              {
                name : 1,
                totalPrice : 1,
                halfPrice : { $divide : [ "$totalPrice", 2 ]}
               }
      }
 ]
)

Output:

{
        "_id" : 4,
        "name" : "Memory Card",
        "totalPrice" : 2500,
        "halfPrice" : 1250
}
{
        "_id" : 7,
        "name" : "Memory Card",
        "totalPrice" : 1000,
        "halfPrice" : 500
}
{
        "_id" : 10,
        "name" : "Memory Carde",
        "totalPrice" : 4000,
        "halfPrice" : 2000
}

Example 3: Wrong data type

The $divide operator only supports integer data types. If the value is not an integer, it gives an error.

db.products.aggregate(
 [
   {$match: {name : "Pen drive"}},
      {
          $project: 
              {
                item_name : 1,
                total_Price : 1,
                Price : {$divide : ["$totalPrice", "$totalQuantity"]}
               }
      }
 ]
)

Output:

uncaught exception: Error: command failed: {
	"ok" : 0,
	"errmsg" : "$divide only supports numeric types, not string and double",
	"code" : 16611,
	"codeName" : "Location16611"
} : aggregate failed :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
doassert@src/mongo/shell/assert.js:18:14
_assertCommandWorked@src/mongo/shell/assert.js:639:17
assert.commandWorked@src/mongo/shell/assert.js:729:16
DB.prototype._runAggregate@src/mongo/shell/db.js:266:5
DBCollection.prototype.aggregate@src/mongo/shell/collection.js:1058:12
@(shell):1:1

Example 4: Using $divide operator in the embedded document

In this example, we're going to divide the total price of the laptop by 2.

db.products.aggregate(
 [
   {$match: { name : "Laptop"}},
      {
          $project: 
              {
                name : 1,
                halfPrice : {$divide: ["$billDetail.totalPrice", 2]}
               }
      }
 ]
)

Output:

{
        "_id" : 9,
        "name" : "Laptop",
        "halfPrice" : 22500
}

Next TopicMongoDB $multiply Operator

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

MongoDB Tutorial

MongoDB Operators

Database Commands

Database

Collection

CRUD: Documents

MongoDB Shell

MongoDB Cloud

MongoDB Tools

Differences

Connectivity

Misc

Interview Questions

MongoDB $divide Operator

What is the $divide operator in MongoDB?

Syntax of the $divide operator:

Examples:

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler