Sum in nested document MongoDB

by

As Sammaye indicated, you need to $unwind the Egresos array to duplicate the matched doc per array element so you can $sum over each element:

db.Cuentas.aggregate([
    {$match: {"Usuario": "MarioCares"} }, 
    {$unwind: '$Egresos'}, 
    {$group: {
        _id: null, 
        "suma": {$sum: "$Egresos.Monto" }
    }}
])

More Related Contents:

  1. Get names of all keys in the collection
  2. How to filter array in subdocument with MongoDB [duplicate]
  3. MongoDB: Combine data from multiple collections into one..how?
  4. mongodb group values by multiple fields
  5. Find in Double Nested Array MongoDB
  6. Multiple join conditions using the $lookup operator
  7. Conditional $sum in MongoDB
  8. Aggregate $lookup Total size of documents in matching pipeline exceeds maximum document size
  9. Get a count of total documents with MongoDB when using limit
  10. exclude fields in $lookup aggregation
  11. How to sum every fields in a sub document of MongoDB?
  12. Add some kind of row number to a mongodb aggregate command / pipeline
  13. MongoDB group by array inner-elements
  14. Exception: can’t convert from BSON type EOO to Date
  15. MongoDB sort documents by array elements
  16. Mongodb Aggregation Framework: Does $group use index?
  17. How to return array of string with mongodb aggregation
  18. How to return just the nested documents of an array from all documents
  19. MongoDB: how to parse date in 3.6 mongoDb version?
  20. convert iso date to timestamp in mongo query
  21. Using $slice operator to get last element of array
  22. Geospatial $near within current document field value
  23. Mongodb aggregation pipeline how to limit a group push
  24. MongoDB : aggregation framework : $match between fields
  25. Find documents whose array field contains at least n elements of a given array
  26. Generating a Structure for Aggregation
  27. MongoDB to Use Sharding with $lookup Aggregation Operator
  28. Mongodb, aggregate query with $lookup
  29. mongodb aggregate query isn’t returning proper sum on using $sum
  30. Return the last “true” value for each group

Leave a Comment