db={"products":[{_id:"5f92a8dfad47ce1b66d4473b",name:"Freno 1",createdFrom:"5f648f7d642ed7082f5ff91f",category:"5f92a00c4637a61a397320a1",description:"Freni di tutti i tipi",sellingPrice:1050,purchasePrice:350}],"purchaseorders":[{_id:"5f930c6c6817832c0d5acbb4",items:[{_id:"5f930c6c6817832c0d5acbb5",product:"5f92abaf17ec621c1da4f4f9",quantity:10,purchasingPrice:1500,discount:300},{_id:"5f930c6c6817832c0d5acbb6",product:"5f92a8dfad47ce1b66d4473b",quantity:7,purchasingPrice:1500,discount:300}]},{_id:"5f930c6c6817832c0d5acbb5",items:[{_id:"5f930c6c6817832c0d5acbb5",product:"5f92abaf17ec621c1da4f4f9",quantity:10,purchasingPrice:1500,discount:300},{_id:"5f930c6c6817832c0d5acbb6",product:"5f92a8dfad47ce1b66d4473b",quantity:7,purchasingPrice:1500,discount:300}]}],"salesorders":[{_id:"5f930c6c6817832c0d5acbb4",items:[{_id:"5f930c6c6817832c0d5acbb5",product:"5f92abaf17ec621c1da4f4f9",quantity:3,sellingPrice:1500,discount:300},{_id:"5f930c6c6817832c0d5acbb6",product:"5f92a8dfad47ce1b66d4473b",quantity:3,sellingPrice:1500,discount:300}]}]}

db.products.aggregate([{$lookup:{from:"purchaseorders",localField:"_id",foreignField:"items.product",as:"purchaseorders"}},{$lookup:{from:"salesorders",localField:"_id",foreignField:"items.product",as:"salesorders"}},{$project:{_id:1,name:1,quantity:{$subtract:[{$reduce:{input:"$purchaseorders",initialValue:0,in:{$add:["$$value",{$reduce:{input:"$$this.items",initialValue:0,in:{$cond:[{$eq:["$$this.product","$_id"]},{$add:["$$value","$$this.quantity"]},"$$value"]}}}]}}},{$reduce:{input:"$salesorders",initialValue:0,in:{$add:["$$value",{$reduce:{input:"$$this.items",initialValue:0,in:{$cond:[{$eq:["$$this.product","$_id"]},{$add:["$$value","$$this.quantity"]},"$$value"]}}}]}}}]}}}])