Total Sum based on max value from another table calculates correctly row by row but overall sum is

Hi Community, My model has different versions of the budget, and version number can vary based on project and department. And I desperately needs help to solve the problem. Regards Jørgen The cod...