Hi, I'm sure this would have been needed before but I can't find it searching the forums

Our contractors fill in a runsheet which can have multiple records per day

I need to count the number of days they had at least 1 record per day .. because I need to know if they did ANY work for more than 80 days within a financial year - payroll tax :-(

ie

date              Hours

16/12/2015    0.5

16/12/2015   2.5  <- I want to omit this record from the count

17/12/2015   3.10

17/12/2015   2.1 <- I want to omit this record from the count

17/12/2015  3.2  <- I want to omit this record from the count

18/12/2015  4.12

they might have 5,000+ records in a FY

omit duplicates omits all the duplicates but I want to leave 1- doesn't matter which 1 ..I can then use a summary field to list each contractor and their total days worked this FY .. there are 165 contractors

 

Thanks

Cate

You can count the distinct dates without omitting the duplicates:

http://fmforums.com/topic/93917-subsummary-count-of-related-parents/#comment-429470

Thanks Comment .. works a treat ...  too tricky for me to have worked out, I was thinking self joins, Position()/List()  etc

Regards

Cate