Hiding A Filtered Portal

[3guk]

Hey Guys,

 

I've got 3 filtered portals on one of my layouts with each portal showing related records based on :-

 

 Events::Status = "Drive"

 Events::Status = "Build"

 Events::Status = "Event"

 

Now what I'd like to do is hide the portal if there are no related records that match each one of the conditions.

 

I plan on using the "Hide Object When" function of the new filemaker, however can't quite work out the calculation required.

 

Is anyone able to point me in the right direction for the calculation required to count if there are any related records that have each one of the conditions as mentioned above !

 

James

[comment]

the calculation required to count if there are any related records that have each one of the conditions as mentioned above !

 

 

Try =

IsEmpty ( FilterValues ( "Drive" ; List ( Events::Status ) )  )