Jump to content

Sum from related TO


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

Recommended Posts

Hi All, if a Sum field is placed in a table showing information from a related table does it always show the sum of that field for all records in the table or can it show just the sum of the found set and if it can be configured to show just the found set, how?

Link to comment
Share on other sites

A calc field that uses Sum (relationship::numberfield) will total the related records. That is, the records included in the total depend upon the relationship. If the relationship, for example, is Client to Invoices by ClientID, then it'll only include the total of the Invoices for that client.

If you describe your setup, we can provide a more explicit answer.

Link to comment
Share on other sites

A calc field that uses Sum (relationship::numberfield) will total the related records. That is, the records included in the total depend upon the relationship. If the relationship, for example, is Client to Invoices by ClientID, then it'll only include the total of the Invoices for that client.

If you describe your setup, we can provide a more explicit answer.

Thank you, that explains it perfectly, I now know what to do. Your help is appreciated

Link to comment
Share on other sites

This topic is 4337 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.