7 Replies Latest reply: Dec 6, 2012 7:01 AM by jagan mohan rao appala RSS

    how to get distinct count of No. of orders

      Hi,

      I wolud like to know the count of unique orders when below conditions get satisfied:

      DateKey>=SelectDateFrom and DateKey<=SelectDateTO

      My expression is:

      COUNT(IF(DateKey>=SelectDateFrom and DateKey<=SelectDateTo,(DISTINCT([Order Count]))))

      i do not know, where I am doing wrong.

      any idea?

       

      Thanks in advance.