2 Replies Latest reply: Sep 28, 2016 6:45 AM by mahesh kumar RSS

    Use multiple conditions in a where clause

    Marc van der Peet

      Dear all,

       

      I would to like show values in a graph based on several conditions. The month should be "aug" and the year should be "2015:)

       

      This works fine:

       

      =count({$<MAAND = {"aug"} >} DATUM_CREATIE)

       

      However when I want to expand it with another condition like this:

       

      =count({$<MAAND = {"aug"} and YEAR ={2015} >} DATUM_CREATIE)

       

      It doesn't work. Any thoughts on what goes wrong here?