1 of 1 people found this helpful
This is a very common database task.
The details of how you do it, depend on what method you use in your "search" as this is something that might be done via:
a) a relationship that matches only to the records for which you want your total
b) A scripted find that finds the records and then returns this total to a record from which the search was initiated
d) A filtered portal where portal filter and related records list the records from which you want a total--not a good option if you then want to use that value in a calculation, but it is possible to do so.
Summary fields can compute totals based on a set of related records (a) or a found set (b). There are SQL aggregate functions such as sum that can be used (c). FileMaker also has an aggregate function, sum that can be used with a). And a summary field can report a total based on a filtered portal (d).