8 Replies Latest reply: May 23, 2016 8:53 AM by Stefan Wühl RSS

    Expression using an OR clause

    Clinton Kitt

      I am trying to put together a criteria in an expression.

      Essentially an OR case

       

      Currently I have :

       

      count({<Stream={'1'}>} CarNP)

      I want to add where it is Stream 1 OR Colour like Red. As the cars maybe in Stream 1 or in another stream but have red within the colour field

       

      count({<Stream={'1'}, Colour = {'*Red*'}>} CarNP)