Articles → MONGODB → $Subtract Operator In The Aggregate Framework Of Mongodb

$Subtract Operator In The Aggregate Framework Of Mongodb

In this article, we will discuss the $subtract operator in the Aggregate framework of MongoDB.

Purpose

In MongoDB, the $subtract operator is used within aggregation pipelines to subtract two numbers or dates and return the difference.

Example

Consider the following collection: -

Picture showing the sample document collection in mongodb

To find the difference between amount and discount, we will use the following query: -

db.sales.aggregate([
  {
    $project: {
      _id: 1,
      date: 1,
      amount: 1,
      discount: 1,
      effectiveAmount: { $subtract: [ "$amount", "$discount" ] }
    }
  }
])

Output

Posted By -	Karan Gupta

Posted On -	Friday, May 10, 2024

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**