Title
novice having trouble getting a sum of multiple fields
Post
I have a field that is a cal sum of two other fields ( one being a summary and the other a cal sum of 9 summary fields) the options are default for the summary fields. The first time i set this up it worked correctly but upon reopening up filemaker pro the field I'm getting a total in access of what it should be. Can someone direct me in how to do this correctly.
More details on this would help.
One factor to look at: Your summary fields compute values drawing from all the records in the current found set. If you change the found set, you will change the results of any calculations that refer to them.