Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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') ;
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.