This field will continually add up all of the records, so when you start it might total to 6 records, and then after a refresh it will be 12 etc etc. Then you modify this within the portal filter calculation itself :Ĭase ( Portal::ConditionIsTrue Let ( $$Total = $$Total + Portal::NumberField 1 ) )Įasy. What you do is use a global variable as the total that you’re displaying at the bottom of the portal, so something like : Yes there is, and you take advantage of the fact that the portal filter calc has to walk the portal records first. So is there a way to get a sum of the filtered records, by just manipulating the UI? ie no scripting ( triggers included ). If you sum a filtered portal you get every record in the relationship, not the filtered records from the portal. So things like a Sum of related records inside a calculated field doesn’t include the filter. I used filters in BaseElements a lot as it’s often showing four or five versions of the same set of related records for difference purposes.īut the other big thing to consider with filters is that they’re part of the User Interface, not part of the Data Model. Generally speaking there can be lots of ways of reducing the complexity of a Relationship Graph by using filtered portals if you think the design through carefully. This can be very handy and is useful to consider when designing your graph.

This is the ability to add an extra criteria to the portal that allows you to limit the records that are displayed. One of the great features introduced in FileMaker Pro 11 is Filtered Portals.

Filemaker pro 11 portals