sum numbers in portal

[thompm65]

Hello,

I am trying to figure out how to total the numbers that show up in a portal. I have a file with land owner names and acreage they own and the location of their property. One landowner can own multiple properties and each property listing is a separate record. I have set up a portal that shows me each record with the acreage listed in each record, i.e. 1, 2.5, 3. Each acreage listed is a separate line in the portal. I would like to have a field in the portal that would list the total amount of acreage for each landowner. Is this possible?

Thanks, MT

[aldipalo]

You don 't tell us how your DB is structured. You should have a table for property owners and a related table of Property Owned. Assuming this in The property Owned table create a summary field:

Property Owned::sTotalAcres

Click create

Choose Total of :AcresField

Set the field below the portal and it SHOULD show you the total of the found set.

Edited November 27, 2006 by Guest

[efen]

You just need an unstored calculation field set below the portal,

Sum(Name_of_portal_relationship::Name_of_your numberofacres_field)

[comment]

I don't think a related summary field will work in version 6. Even in the current version, it's still an 'undocumented feature'. Better stick to the conventional method of:

Sum ( Properties::Acreage )

[John Mark Osborne]

A related summary field will work in FileMaker 7 or later, even though it didn't work in FileMaker 6, but it has refresh issues. I agree with Comment to stick with the conventional approach and use an Aggregate function.

[thompm65]

Hi,

I'm trying to figure out which answer to use. Do all of the answers assume I have two tables as mentioned in the first answer to my question? I'm new to setting up relationships and the calculation mentioned in the last post, so I couldn't quite figure out what to do.

I do appreciate the answers but need a little more info. On the other hand, maybe you need more from me!

Thanks!

MT

[efen]

It can be done in one file or two. See attachment for a simple example in one file done in FM 6.

sumfield.zip

[thompm65]

I got it!

It works.

Thanks for all of the help.

MT