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

    Use multiple conditions in a where clause

      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?