4 Replies Latest reply on Oct 28, 2009 10:23 AM by ww

novice having trouble getting a sum of multiple fields

ww Oct 28, 2009 8:31 AM

Title

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.

1. Re: novice having trouble getting a sum of multiple fields

philmodjunk Oct 28, 2009 9:23 AM (in response to ww)

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.
Like Show 0 Likes(0)

Actions
2. Re: novice having trouble getting a sum of multiple fields

ww Oct 28, 2009 9:28 AM (in response to ww)

PhilModJunk,

These fields are tracking donations and do change monthly. Does this shed enough light on my conundrum?
Like Show 0 Likes(0)

Actions
3. Re: novice having trouble getting a sum of multiple fields

philmodjunk Oct 28, 2009 9:38 AM (in response to ww)

Nope.

Spell out the field definitions.

Any relationships involved or are all the fields being used part of the same table?

What happens to the displayed values of these calculations when you close/reopen the file?

Are you always examining these values with the same exact found set or might reopening the file change the found set to give you a different result from what you expect?
Like Show 0 Likes(0)

Actions
4. Re: novice having trouble getting a sum of multiple fields

ww Oct 28, 2009 10:23 AM (in response to ww)

Thanks your last question was where I blew it. Its now accurate.
Like Show 0 Likes(0)

Actions

Go to original post