Jump to content

Summing Donation totals in a portal for FM7


FM7Newbie
 Share

This topic is 6488 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hey Everybody, hopefully I'm not repeating a post b/c I looked around but I'm trying to figure out exactly how to use a script to find the sum of some displayed figures... Basically our database is set up for donators of which you can view the history of each particular person or company via a portal with the pertinent information.

Basically, I want to write a script for a calculation field found underneath the portal that takes the Amount field from each donation instance in the portal and sums them up and places the grand total in the calculation field "Total". Every script I have tried just adds the values in a horizontal fashion but we need it to go down the list and add those values... any ideas???

Here's an example of what the portal looks like FYI:

--------------------------------------------------------------

Donation Type: Cash Amount: 50.00 Date: 03/29/02

Donation Type: Check Amount: 490.00 Date: 05/28/04

--------------------------------------------------------------

(end of portal)

Grand Total: 540.00 <-- But I cant get this to sum right...Thanks in advance!

FileMaker Version: 7

Platform: Windows XP

Link to comment
Share on other sites

A script isn't necessary, this can be done with a calculation field.

In the file that has the portal, and assuming the portal is using a relationship named "PortalRelationship ": define a calculation field and set it to: Sum(PortalRelationship::Amount)

Place the calculation field on the layout outside of the portal & Voila!

Does this do what you need?

Link to comment
Share on other sites

I have tried placing the Grand Total field outside the portal (called "Donations") and Grand Total field is defined as a calculation set to:

Sum(Donations::Amount)

It will only display the value in the first Amount field.

Using Example from above it would only display "$50" , not "$490" or "$540"

UPDATE:

I have figured out to do this with a script using the "Insert Calculated Result [Donations::Total; Sum(Donations::Amount)]"

Though I still don't understand why the above method you suggested isn't working.

Link to comment
Share on other sites

I'm still using FM6 and am having a similar problem (see my post), but if it's the same, what I've been doing is creating a new TRIALING GRAND SUMMARY part and putting the Summary field inside a portal in this new part. Works MOST of the time...

Link to comment
Share on other sites

This topic is 6488 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.