I'm new at this so bear with me, i've been asked to compile a KPI for the company. the client would like to see how many operatives are working on a site at a given point in time.
they would like to know:
how many of them are from within the same area as the site.
how many of the site operatives working are not from the area.
how many are trainees from area
how many trainees are from outside the area.
I can filter to show the number of opperatives on site at a given time and can produce a list of the employees that are from the same post code as the project. what i can't do is give the split. I know that you can link tables together but have not had to use that function up until now. Here's my attempt at linking the tables but as I say I can't get it to return the correct value. =NL("Count","Timesheet Hour Details",,"Shortcut Dimension 1 Code",$B$4,"Date",$F$12,"Hours","<>0","Employee No.",NL("Count","Employee",,"Post Code",B5))
any help would be appreciated
Cheers
Dean
Date
Votes
1 comment
-
Jet Reports Historic Posts You may be able to accomplish this using the Jet Link= functionality like this:
=NL("Count","Timesheet Hour Details",,"Shortcut Dimension 1 Code",$B$4,"Date",$F$12,"Hours","<>0","Link=","Employee","No.","=Employee No.","Post Code",B5)
Is that more what you're trying to do?
Regards,
Hughes
Please sign in to leave a comment.