8 Replies Latest reply: Sep 15, 2015 1:04 PM by Sunny Talwar RSS

    Count date if greater than zero

    Kevin Stephenson

      I have a set of date for example

      Client RefCase RefStart DateEnd Date
      158110/11/1414/01/15
      158210/11/1414/01/15
      158310/11/1414/01/15
      1231
      1232
      14716/7/1410/9/15
      14726/7/1410/9/15
      14736/7/1410/9/15
      14746/7/1410/9/15

       

       

      What I need to do it count the Distinct Client Ref but only if the Start date is Greater than 0

       

      What I have is:

       

      If ([Start Date] > 0, Count (Distinct [Client Ref]))

       

      I have tried using this with my data and it returns with a value of 4 but I know there are thousands as we have about 100,000 clients in our Data base.

       

      Thanks in advance