2 Replies Latest reply: Jun 18, 2012 12:52 PM by Hardik Gandhi RSS

    Expression (Syntax Modification)

    Hardik Gandhi

      Hi,

       

      =sum(aggr(count(distinct [Person ID]),Date))            - Counts the Person ID.

       

      Req: I want to create a Text object which shows only the count for Current Year and Month. ( vCurrentMonth & vCurrentYear - Created)

       

      How to accomodate the above requirement in existing syntax for count which is =sum(aggr(count(distinct [Person ID]),Date))

       

      Thanks,

      H