db={"users":[{"_id":{"$oid":"5f8f1fa7b5212c7388bbae71"},"discord_id":"85479273153966080","username":"Chille#9733","character":"Chillelight","server":"illidan","serverid":11}],"runs":[{"_id":{"$oid":"5f91d6d03119c516d8e2c365"},"advertiser":"85479273153966080","adType":"legendary","typeOfBoost":"mythic_plus","goldAmmount":"250000","server":"tichondrius","serverID":6,"boosters":["85479273153966080","131939237468700672","85479273153966080","131939237468700672"],"boosterCut":48437.5,"advertiserCut":62500,"communityCut":139062.5},{"_id":{"$oid":"5f91d6d03119c516d8e2c366"},"advertiser":"85479273153966080","adType":"legendary","typeOfBoost":"mythic_plus","goldAmmount":"250000","server":"tichondrius","serverID":6,"boosters":["85479273153966080","131939237468700672","85479273153966080","131939237468700672"],"boosterCut":48437.5,"advertiserCut":62500,"communityCut":139062.5}]}

db.users.aggregate([{"$match":{"serverid":11}},{"$lookup":{"from":"runs","localField":"discord_id","foreignField":"advertiser","as":"adRuns"}},{"$lookup":{"from":"runs","localField":"discord_id","foreignField":"boosters","as":"boosterRuns"}},{"$match":{"adRuns._id":{/** "$gte": ObjectId("5f91d6d83119c516d8e2c364"),*/"$lte":ObjectId("5f91ffffffffffffffffffff")}}},{$addFields:{adRunsSum:{$reduce:{input:"$adRuns",initialValue:{boosterCut:0,communityCut:0,advertiserCut:0},in:{$mergeObjects:["$$value",{boosterCut:{$add:["$$this.boosterCut","$$value.boosterCut"]},communityCut:{$add:["$$this.communityCut","$$value.communityCut"]},advertiserCut:{$add:["$$this.advertiserCut","$$value.advertiserCut"]}}]}}}}}])