Filemaker is not a spread sheet application. It does things more interms of related records in sets of fields.
If you used an aggregate function such as sum, then you have these options:
Sum ( field 1 ; field 2 ; field 3 ; field 4.... field N )
Sum ( RelatedTable::Field 1 )
Sum ( RepeatingField )
I recommend that you not have 130 fields in one record to sum. Nor should you use a single field with 130 repetitions. Instead, create a related table and sum the records in the related table.
Not only can sum use a relationship to sum the values of a single field across a set of related tables, you then have the option of using a summary field to compute the same total and that will offer additional options for computing totals and sub totals.
I've tried to reply twice to your comment, but the Forum won't let me. Thanks for trying to help. :P
Oh great, that comment it lets me post. Sheesh.