[{"_id":"62b46391be7c618aa5c9bf86","virtualAmount":{"value":3370,"currency":"EUR","paid":0,"discount":0},"kind":"Business","invoiceNumber":"TEST57938","reference":"TEST57938","dueDate":"2022-07-01T09:26:36.343Z","invoiceDate":"2022-06-23T12:58:54.664Z","transactions":[{"_id":"62b46645be7c618aa5c9bf97","transactionReference":null,"valueDate":null,"bookingDate":null,"deleted":true,"type":"Transfer","method":"UNKNOWN","amount":{"value":337,"currency":"EUR"},"date":"2022/06/23","account":"62ab685e5a7d9518de0cfa29","reference":"TEST57938","remarks":"","createdBy":"62ab68395a7d9518de0cfa1a","createdAt":"2022-06-23T13:10:29.914Z","updatedAt":"2022-06-23T13:11:00.615Z","__v":0,"deletedAt":"2022-06-23T13:11:00.609Z"},{"_id":"62b470951ad7c48cb323e3f7","transactionReference":null,"valueDate":null,"bookingDate":null,"deleted":false,"type":"Transfer","method":"UNKNOWN","amount":{"value":1000,"currency":"EUR"},"date":"2022/06/23","account":"62ab685e5a7d9518de0cfa29","reference":"TEST57938","remarks":"","createdBy":"62ab68395a7d9518de0cfa1a","createdAt":"2022-06-23T13:54:29.917Z","updatedAt":"2022-06-23T13:54:29.917Z","__v":0}],"creditnote":[{"_id":"62b476f459b3aa8e918fae81","deleted":false,"amount":{"value":1000,"currency":"EUR"},"file":"62b476f359b3aa8e918fae80","remarks":"","uploadedBy":"62ab68395a7d9518de0cfa1a","createdAt":"2022-06-23T14:21:40.487Z","updatedAt":"2022-06-23T14:21:40.487Z","__v":0}],"deleted":false,"amount":{"value":3370,"currency":"EUR"},"customer":{"_id":"62ab689d5a7d9518de0cfa68","kind":"Business","score":null,"addresses":["62ab689d5a7d9518de0cfa67"],"communicationLanguage":"nl","isAutomatic":false,"chargePenalty":false,"isVerified":false,"deleted":false,"offerflow":"62ab685f5a7d9518de0cfa3f","invoiceflow":"62ab685f5a7d9518de0cfa40","externalId":"","firstName":"","lastName":"","name":"Harper Jones","email":"wouter@cuneocashflow.com","contacts":[],"account":"62ab685e5a7d9518de0cfa29","remarks":"","createdAt":"2022-06-16T17:30:05.628Z","updatedAt":"2022-06-16T17:30:05.628Z","__v":0},"file":"62ac48cb263ad42429f3b570","status":"Saved","info":null,"ultimateDueDate":"2022-07-01T09:26:36.343Z","account":"62ab685e5a7d9518de0cfa29","upload":"62ac48cc263ad42429f3b581","createdBy":"62ab68395a7d9518de0cfa1a","createdAt":"2022-06-23T12:58:57.972Z","updatedAt":"2022-06-23T14:21:40.848Z","token":"375ac4035ece708123a07c26856c393e9621b166","replyId":"96a7696e5c2ac05b09603bee5575556ced8e4294","__v":10,"externalDebtCollection":null}]

db.collection.aggregate([{$match:{deleted:false}},{$group:{_id:{_id:"$transactions",},totalSaleAmount:{$sum:"$transactions.amount.value"},}}])