Database
[{"_id":ObjectId("5ea970747cd4ac05869977ec"),"sex":"Male","first_name":"Wayne","last_name":"Fields","job":"Speech Pathologist","email":"wfields0@diigo.com","location":{"city":"Oyo","address":{"streetname":"Beilfuss","streetnumber":"860"}},"description":"vulputate justo in blandit ultrices enim lorem ipsum dolor sit amet consectetuer adipiscing elit proin interdum mauris","height":"152.38","weight":"66.81","birth_date":"1990-02-21T02:55:03Z","nationality":"Nigeria","credit":[{"type":"switch","number":"6759888939100098699","currency":"COP","balance":"5117.06"}]}]
Query
db.collection.aggregate([{$unwind:"$credit"},{$group:{_id:{currency:"$credit.currency"},sumCur:{$sum:{$toDouble:"$credit.balance"}}}}])