3 Replies Latest reply: May 11, 2016 9:47 AM by Chris Waterworth RSS

    If Statement with multiple correct answers

    Chris Waterworth

      Hi Guys,

       

      Just a quick one if have an if statement where there are 3 potential right answers (4,5 or 6). What is the correct syntax for 'OR' statements?

       

       

       

       

      if(Month([Pickup Date])=('4,5,6'),Sum(Pop2016)+Sum([Peak Tourist Pop])

       

      Any help would be appreciated.

       

      Cheers,

       

      Chris