14 Replies Latest reply on Dec 23, 2012 12:27 PM by brian.curran

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


      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?