Employees::Division Participaiton = SRTraffic::Division and Employees::JobType Participation = SRTraffic::Interested in and Not IsEmpty ( FilterValues ( Employees::Service Area Zips ; SRTraffic::Zip ) )
Employees::Division Participaiton = SRTraffic::Division and Employees::JobType Participation = SRTraffic::Interested in and ValueCount ( FilterValues ( Employees::Service Area Zips ; SRTraffic::Zip ) )
Should serve here.
I have been reading a lot of your posts/answers on the forum...you know you are a Genius right? Will you marry me? (just kidding of course)
I have been wallowing around in the basement of existence with FileMaker 4.0 for almost 20 years. It still works pretty good but since I have seen the light of day with FMP11, I'm like a fat kid in a candy store! Thanks for getting me over that hump, your awesome. -DJ
Another tip is that you can use the Case function to refer to a Global Field and Apply completely different filters on the same portal.
For example you wanted to unfilter the portal you could use a global field with radio buttons for filter and show all and use a case statement to evaluate the global field value and apply whichever filter calculation you wish.
You may need to apply a Refresh Window [Flush Cached Joins] as a on object modify script trigger for the global field but makes a neat trick.
Just more candy for you. :)
Nice. Love it. Thanks. -DJ