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

    If Match function with AND or OR?

    Ryan Minaker

      Hi,

       

      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'

       

      Thanks!

       

      R.