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?

       

      Thanks

      Rentia