My first post here, be gentle...
I have a layout named 'Site' that has a portal to a join table called '_JoinPeopleSite'. This returns a list of people, assigned a certain 'role' for the Site. This works great, the filter being used is:
not IsEmpty ( FilterValues ( _JoinPeopleSite::Role ; "Incidents" ) )
I also have a Calculation field in the Site table, which generates a comma separated list of email addresses:
Substitute ( List ( People.Site::WorkEmail ) ; "¶" ; ";" )
What I would like to do is combine the filter within the Calc field if possible, can this be done without delving too much into relationships?