When I use the following table and perform a find. I like to see a sum of a particular field after doing the find. Ideas on how to achieve this? Thanks!
there are 'statistic' fields available. If they are placed in the footer part (for example), they will show sum, avg, whatever is available (based on the found set)
Check field types in manage database/fields
They are called summary fields:
FileMaker Pro 17 Advanced Help
You may wish to study these help topics on the Table View:
Working with data in Table View
Displaying and hiding fields in Table View
Creating dynamic reports in Table View
I think the last one would be of particular interest to you! You can add the 'subtotals' right in Table View.
Note: You can view the quick report only in Table View. The changes you make have no impact on the current layout.
Retrieving data ...