Hi! New to Filemaker and trying to find out how to get a total from a field that is sorted by a category.

There is a listing of items and amounts paid that also have a corresponding variable. There are six different variables and I need a seperate sum for each variable. Any guidance on how I might set up a function or calculation to find this?

Thanks in advance!!!

to my knowledge the only way to have a true Summary is to create a summary field, run a search and then get the number.

It would be a script that has six searches in it, each time for your different variables, when your done with the search, throw the value of your summary field into another field and go to the next one. That will ge tthe job done, however I'm sure there is someone here way smarter than me who could give you a really nifty way to do this.

And, now that I mention it, you can probably do this automatically with the list/report method when creating a new layout. Not positive how that would work though.

Thanks for the info! I haven't tried scripts yet- will give it a try. Thanks again.