Forum Discussion
Trouble adding two sums
You need to check your relationships in the data model tab. The reason that the Total Materials Cost was working was that it was all within a table and so it had no reason to check relationship between the tables. However, the Total Labor used two separate tables and so the relationship mattered. There was no active direct relationship between the two tables so it was no able to grab the second table information.
So the answer to this problem was that the relationships were not properly set up!
You need to check your relationships in the data model tab. The reason that the Total Materials Cost was working was that it was all within a table and so it had no reason to check relationship between the tables. However, the Total Labor used two separate tables and so the relationship mattered. There was no active direct relationship between the two tables so it was no able to grab the second table information.
So the answer to this problem was that the relationships were not properly set up!