Sum across records in a found set

[Jacobo]

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.

[webko]

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

[comment]

No, you need to use a summary field.

[webko]

My bad - missed that it wasn't a Summary field to start with...

[comment]

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).

[Jacobo]

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.