7 Replies Latest reply: Jul 18, 2013 9:03 AM by Vishwaranjan Kumar RSS

    Count and IF statement in one expression

      Hi there,


      I am trying to do a distinct count of the  number of contracts (agreement numbers) we have in May. (Instalment Date for May)


      I am using the following expression, but it show zero value:



      count ({<[Instalment Date]={'01/05/2013'}>}DISTINCT [Agreement Number])


      What am I doing wrong?