Database

[{"_id":ObjectId("6239a3c93a8e84c1b46d1bf4"),"category":"음식","keyword":"삼겹살","weight":0,"shard":5,"searchCount":3,"satisfactionCount":4,"force":false}]

Query

db.collection.update({},[{$addFields:{/** weight = (searchCount X 0.5 + satisfactionCount X 0.5)*/weight:{$trunc:[{"$sum":[{"$multiply":["$searchCount",0.5]},{"$multiply":["$satisfactionCount",0.5]}]},0]}}}])

Result