Newbies Jacobo Posted May 6, 2016 Newbies Share Posted May 6, 2016 Sorry for this potentially simplistic question, but I have looked into several options and can't find one that works exactly. My issue: I have created a word count field that calculates the word count of a "Content" field for each record in a table ("Notes"). I am trying to figure out how to calculate the sum total of that word count value across all records in a found set. Any ideas on how to best accomplish this? I created a "WordCountTotal" field in the same table, and set it as a calculation using "Sum(WordCount)", but it only seems to give the value for the currently browsed record, and I cannot figure out how to get it to calculate the summed value of all current records. Thoughts or suggestions would be much appreciated. Link to comment Share on other sites More sharing options...
webko Posted May 6, 2016 Share Posted May 6, 2016 You would need to place the field in a Part that supports Summing across multiple records - see http://www.filemaker.com/help/12/fmp/html/create_layout.9.18.html Link to comment Share on other sites More sharing options...
comment Posted May 6, 2016 Share Posted May 6, 2016 No, you need to use a summary field. Link to comment Share on other sites More sharing options...
webko Posted May 6, 2016 Share Posted May 6, 2016 My bad - missed that it wasn't a Summary field to start with... Link to comment Share on other sites More sharing options...
comment Posted May 6, 2016 Share Posted May 6, 2016 Note also that a summary field can be placed in any part. Only when it it's placed in a sub-summary part, it will show a sub-summary value. In all other parts, it will show the summary value for the entire found set (running summaries excepted). Link to comment Share on other sites More sharing options...
Newbies Jacobo Posted May 9, 2016 Author Newbies Share Posted May 9, 2016 Thank you all. I got it working correctly as a summary field, and the clarification about the type of part in which the field is placed was also useful. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2908 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