I faced the same thing in one of my apps. Instead of doing a lookup…create a rollup from the relation.
Sum lookup values?