Combining a Filter and a List in a Calculation field...

Discussion created by brian.curran on Dec 21, 2012
Latest reply on Dec 23, 2012 by brian.curran

Hi all,

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?