1 Reply Latest reply on Mar 10, 2010 11:17 PM by comment_1

    Filemaker Pro 11 - Portal Filtering

    bcheang

      Summary

      Filemaker Pro 11 - Portal Filtering

      Description of the issue

      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?