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

    Expression (Syntax Modification)

    Hardik Gandhi



      =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))