calculating percentage in subsummary

[GoldbergDA]

I have two databases - a mailing database (contains the number of pieces in a mailing) and a donations database (contains the number of donations received from each mailing).

I want to be able to calculate my response rate from each mailing.

In the donations database, I track each donation in a field called "Amount". I have a report in the donations database with a sub-summary with these fields:

"Number of Gifts" (summary field) = Count of Amount

"# of items mailed" (from the mailing database)

When I create a calculation field to produce a percentage of these two fields, instead of the calculation taking the sub-summary "Number of Gifts", it takes the "Number of Gifts" from the WHOLE database. The calculation seems to make the field lose its ability to summarize and only give me a subset of the data I want.

Any ideas?

Edited January 28, 2007 by Guest

[Søren Dyhr]

My problem with your post is that it's ages ago I had your version installed on any machine in my vicinty. But if you create a new file with the field definitions listed above, and imports the data stored as tab delimited data in the attachment.

The example is found here:

http://www.filemakerpros.com/PERCENT2.zip

But see if you can build the file on the field defs. and script shown here???

--sd

johnsData.zip

[Lee Smith]

I deleted your duplicate post and adjusted the subject.

Please do not double post in the Forum.

Lee

[GoldbergDA]

You know, I saw the "GetSummary" field in your screenshot and said to myself "That's gotta be it!". And it was. Once I used that field in my calculation, the correct percentages came up without a problem.

Thank you SO much!