Filemaker Pro 11 - Portal Filtering
I don't know if this is a bug, but it sure looks like one to me. Let's say you have a normal portal displaying 5 related records. If you do a Count ( fieldname ) it will give you the number of records showing in the portal. Now with Filemaker 11, lets say I apply a filter condition and this time, that same portal shows me 2 related records. The count still shows 5 records, instead of 2. Similarly, if you do a Sum ( number field ) you will get the total of all fields (including the hidden ones). I think that Count, Sum and other functions should operate only on the visible set of related records. Don't you think?
Count, Sum and other functions operate on the related set - whether visible or not (they will work the same even when there is no portal at all).
However, take a look at: