May 6, 20169 yr Newbies 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.
May 6, 20169 yr 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
May 6, 20169 yr 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).
May 9, 20169 yr Author Newbies 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.
Create an account or sign in to comment