Cateleb Posted January 28, 2016 Share Posted January 28, 2016 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 Link to comment Share on other sites More sharing options...
comment Posted January 28, 2016 Share Posted January 28, 2016 You can count the distinct dates without omitting the duplicates: http://fmforums.com/topic/93917-subsummary-count-of-related-parents/#comment-429470 Link to comment Share on other sites More sharing options...
Cateleb Posted January 28, 2016 Author Share Posted January 28, 2016 Thanks Comment .. works a treat ... too tricky for me to have worked out, I was thinking self joins, Position()/List() etc Regards Cate Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3138 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now