1 Reply Latest reply: Sep 25, 2012 6:01 AM by Alwin Scheerens RSS

    Conditional count

    phil rumbold

      How do I create an expression for a count of the number of records in a table that is conditioned by another row in the the table?

       

      for example, the script below produces the total number of records, whereas I want total number of records created on or after 1st August 2012

       

      RecCount:

      Load count(distinct [rec key]) as [record Count]

       

      From

      [PR C121881.xls]

      (biff, embedded labels, table is Sheet1$)

      WHERE([record Created] <= '01/08/2012') ;