thompm65 Posted November 27, 2006 Share Posted November 27, 2006 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 Link to comment Share on other sites More sharing options...
aldipalo Posted November 27, 2006 Share Posted November 27, 2006 (edited) 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 Link to comment Share on other sites More sharing options...
efen Posted November 27, 2006 Share Posted November 27, 2006 You just need an unstored calculation field set below the portal, Sum(Name_of_portal_relationship::Name_of_your numberofacres_field) Link to comment Share on other sites More sharing options...
comment Posted November 27, 2006 Share Posted November 27, 2006 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 ) Link to comment Share on other sites More sharing options...
John Mark Osborne Posted November 27, 2006 Share Posted November 27, 2006 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. Link to comment Share on other sites More sharing options...
thompm65 Posted November 28, 2006 Author Share Posted November 28, 2006 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 Link to comment Share on other sites More sharing options...
efen Posted November 28, 2006 Share Posted November 28, 2006 It can be done in one file or two. See attachment for a simple example in one file done in FM 6. sumfield.zip Link to comment Share on other sites More sharing options...
thompm65 Posted November 28, 2006 Author Share Posted November 28, 2006 I got it! It works. Thanks for all of the help. MT Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6351 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 accountSign in
Already have an account? Sign in here.
Sign In Now