Calculate Number of Portal Rows After Filtering

[Melinda O'Brien]

First, I'm using FileMaker Pro 11 Advanced on a Mac platform

 

I've created a calculation that returns the number of rows that appear in my portal, but it only shows the number of rows before the portal filter is applied. My calculation is this:

 

Count ( Child::MatchField ) 

 

I've managed to do this on other layouts by creating a match field that encompasses all the criteria for the records that I want to appear in the portal. However, this particular portal iis filtered by variable information that basically allows me to narrow my results to more specific data. For example: In the Parent table, I have one record and in the Child table I have 20 records that match the criteria for the relationship which is:

 

Parent::PrimaryMatch = Child::PrimaryMatch

 

The portal filter returns any or all of the following matches:

 

Parent::Value1 = Child::SecondaryMatch or 

Parent::Value2 = Child::SecondaryMatch or

Parent::Value3 = Child::SecondaryMatch

 

Which returns only 8 records.

 

How do I get the Portal Row Count to only show 8 instead of 20?

 

[eos]

Create a summary field in the portal table as Count of primaryID. On your layout, create a one-row portal with the same filter as your other portal, and place the related summary field in the portal. This will display the count of portal records.

 

To use this number within a calculation, give the field an object name in Inspector, Position tab and use GetLayoutObjectAttribute ( "objectName" ; "content" ).

[Melinda O'Brien]

Trying that now. 

 

Thanks!

[Melinda O'Brien]

It worked like a charm. I knew there would be a simple solution!