I am working on a database that is calculation heavy. I am using relationships to define the calculations and have run into a stump. I think it is because I am doing calculations on calculations and am beginning to think I need to do the calculations differently. I have a couple of screenshots here.
Here is the table I am working with. The last four calculations are what I use to total the daily and monthly numbers.
Here is the result of the table.
Notice that the last two columns do not calculate. The last one would not have any numbers in it anyway because we have zero's in the third to last column.
Here is what the relationship looks like.
My questions is, am I doing too many calculations on calculations?
Any help would be appreciated.