Jump to content

Sum across records in a found set


Jacobo
 Share

This topic is 2241 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

This topic is 2241 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.