Adding a grand total of related records in a find

[Karend440]

Wonder if I can get some help with this?

I have a database that consists of employees, a week ending date, hours worked on a particular job, and a job number.

What I am trying to do, is when I do a find for a particular person, it will give me the hours worked by employee. How can I add on, the grand total number of hours from everyone, on this particular job? What I am trying to show, is their total hours, and the total hours of the job by everyone. This will enable me to get the % of their hours worked. Right now, the best I can get is it just totaling up for that particular employee only, not the total for the entire job.

I can't seem to get the grand total of all the hours, complete for the job.

Any help is certainly appreciated, thanks!

[comment]

I am not sure I follow this fully - it seems a report sub-summarized by job and employee should produce what you want, i.e:

Job A:

• Adam ... 5 hours

• Betty ... 3 hours

• Cecil ... 4 hours

Total of Job A: 12 hours

Job B:

• Adam ... 3 hours

• David ... 6 hours

Total of Job B: 9 hours

[Karend440]

Thanks for the response :, maybe I can make this a bit clearer? I have many employees, that work on particular jobs, that last for months. What I am looking to do, is (which I can now..) is do a find on one person, to total their hours put to this job. What I need to add to this report is also a total of everyone's hours also put to this job, a grand total, showing the total hours for all. (i.e. Tom has 56 hours, and total for all is 356 hours. I can do either or, but not both together. Thats what I am trying to figure out. Sort of like a mixed search on the same report. This is what I am not sure is possible? ok, maybe, but it's beyond me.

Many thanks!

[comment]

It is possible to do it the way you describe, if you "steal" the total for a job from the related job record. But it would be much simpler if you produced the report for all employees at the same time.

[bruceR]

Seems like just a standard summary field is required. Is there some reason that doesn't work? You do know how to do summary field and standard sub-summary reports?

[Karend440]

Thanks for the help, yes I already have a standard summary field, it's working just fine. The the issue is, to add another summary field that contains the total from everyone that worked on it, assuming I just did the search for one person, or a group. I think I am going to try the previous post of stealing it from another field setup that will have it, and see if I can get that to work. But... thank you both for the suggestions! I certainly appreciate it!

Thanks Again!

[bruceR]

No, you do not have to add another field.

You have to add another PART.

Just put the summary field in the trailing grand summary part.

Like I said, this is just basic FileMaker summary reporting.

[comment]

the issue is, to add another summary field that contains the total from everyone that worked on it, assuming I just did the search for one person, or a group.

If you did a search for one person, or a group, then a summary field placed in a trailing grand summary part will show the total for that person/group.

[Karend440]

Resolved this by adding another layout with a field containing the grand totals of all, then doing a lookup of these totals to add to the report I was trying to do. Basically, when doing a find of a few members, the summary and parts only adds up those finds in the totals, but wanting to do a comparison to those found as a percentage to the whole, I took the 'whole' amount and did a lookup to bring that in. Worked out okay in the end. Thanks to all for the responses and help, much appreciated!