Hello,

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.

Doing calculations on calculations, or being "calculation heavy" is not

inherentlya bad thing. It's possible to set up calculations that take a long time to perform, cause undue dependencies that affect performance, or just plain don't work because they are circular or your calcs fire in the wrong order, but mistakes can be made with all the other tools, too.I think your issue here may be that LOG_MONTH and LOG_YEAR are unstored, and unstored fields can't be used on the "right" side of the relationship?

Chris Cain

Extensitech