[{"_id":{"$oid":"614e0f8fb2f4d8ea534b2ccb"},"userEmail":"abc@example.com","customId":"abc1","amountIn":10,"amountOut":0,"createdTimestamp":1632505743,"message":"","status":"ERROR"},{"_id":{"$oid":"614e0f8fb2f4d8ea534b2cdb"},"userEmail":"abc@example.com","customId":"abc1","amountIn":12,"amountOut":5,"createdTimestamp":1632505743,"message":"","status":"ERROR"}]

db.collection.aggregate([{$match:{"createdTimestamp":{"$gte":1632430800,"$lte":1632517200}}},{$group:{_id:null,total_amount:{$sum:{$cond:[{$gt:["$amountOut",0]},"$amountOut","$amountIn"]}}}}])