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?

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.

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