Check the Map/Reduce script type in help. That should do the trick. If one update per day is also enough, you can do it easily via scheduled mass update, this way no scripts will be required at all.