How to aggregate sum in MongoDB to get the total count?

To aggregate sum in MongoDB to get the total count, you can use the $sum operator. To understand the above concept, let us create a collection with the document −

> db.aggregateSumDemo.insertOne({"CustomerName":"Larry","Amount":140});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8baa0680f10143d8431e18")
}
> db.aggregateSumDemo.insertOne({"CustomerName":"Mike","Amount":160});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8baa1380f10143d8431e19")
}
> db.aggregateSumDemo.insertOne({"CustomerName":"Sam","Amount":300});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8baa1c80f10143d8431e1a")
}
> db.aggregateSumDemo.insertOne({"CustomerName":"David","Amount":500});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5c8baa2580f10143d8431e1b")
}

Display all documents from a collection with the help of find() method. The query is as follows −

> db.aggregateSumDemo.find().pretty();

The following is the output −

{
   "_id" : ObjectId("5c8baa0680f10143d8431e18"),
   "CustomerName" : "Larry",
   "Amount" : 140
}
{
   "_id" : ObjectId("5c8baa1380f10143d8431e19"),
   "CustomerName" : "Mike",
   "Amount" : 160
}
{
   "_id" : ObjectId("5c8baa1c80f10143d8431e1a"),
   "CustomerName" : "Sam",
   "Amount" : 300
}
{
   "_id" : ObjectId("5c8baa2580f10143d8431e1b"),
   "CustomerName" : "David",
   "Amount" : 500
}

Here is the query to get the total count.

Case 1 − The query is as follows −

> db.aggregateSumDemo.aggregate([ {
   ... $group: {
      ... _id: null,
      ... "TotalCount": {
         ... $sum:1
      ... }
   ... }
... } ] );

The following is the output −

{ "_id" : null, "TotalCount" : 4 }

Here is the query to aggregate sum in MongoDB to get the total sum.

Case 2 − The query is as follows −

> db.aggregateSumDemo.aggregate([ {
   ... $group: {
      ... _id: null,
      ... "TotalAmount": {
         ... $sum: "$Amount"
      ... }
   ... }
... } ] );

The following is the output −

{ "_id" : null, "TotalAmount" : 1100 }

Nishtha Thakur

Updated on 30-Jul-2019 22:30:25

• Related Questions & Answers
• How to calculate sum in MongoDB with aggregate()?
• MongoDB aggregate to get the count of field values of corresponding duplicate names?
• Get substring in MongoDB aggregate
• MongoDB aggregate to get the Mean daily average count of recorded documents in a collection?
• MongoDB aggregate $slice to get the length of the array
• How to get only values in arrays with MongoDB aggregate?
• MongoDB $unwind to get the count
• How to use MongoDB Aggregate to sort?
• Get the average of marks in MongoDB with aggregate?
• How to aggregate array documents in MongoDB?
• How to update after aggregate in MongoDB?
• Get a count of total documents with MongoDB while using limit?
• MongoDB aggregate query to sort
• Using MongoDB Aggregate and GroupBy to get the frequency of name record
• Aggregate based on array value to sum values in different MongoDB documents?