2 Replies Latest reply: Aug 12, 2016 3:05 PM by Ryan Minaker RSS

    If Match function with AND or OR?

    Ryan Minaker



      Can someone please tell me if it's possible to use AND or OR with a the Match function?


      I'm trying to create a custom dimension where I want to pull records from staff who are [Active] and in [Toronto] and name this as 'Available/Toronto'.

      The match statements work fine on their own, but I need to combine them using AND. I've tried using several different ways to do this and can't get it to work. Any help, much appreciated.



      if(match([Status],'Active'), 'Available/Toronto'

      if(match([Location],'Toronto), 'Available/Toronto'