Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
philrumbold
Contributor
Contributor

Conditional count

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') ;

1 Reply
alwinsch
Creator
Creator

 

Hi,

I used the function below

  

count ({<[Interne Comm - Binnen uw dienst]={'Voldoende'}>} distinct [MW Naam])

where

[Interne Comm - Binnen uw dienst] has to be your date field

and [MW Naam] is your number field

Regards,

A.