Summary of Multiple Related Fields

[life036]

Hello Everyone,

I'd like to add together all the numbers in a field of only the related records. The thing is, I'd like to do this for multiple fields at once. I'm aware that you can do the sub-summary and sort by that field to get a count of related records, but I'd like to do that for more than one at a time. Here's a Picture of what I mean - See all the zeroes on the bottom? I'd like those to be the added up totals of what is in the portal:

Is this possible with FMP 6? I also have 8 if I need to use that instead...

Thanks for any info you could provide!

Chris

Edited July 5, 2007 by Guest

[Vaughan]

A calculation field with Sum( relationship::field ) should do it.

[life036]

Awesome, thanks!

Don't know why I couldn't get that to work before, but it works great now!