Do you want utilization based on work assigned or work actually performed? (You assign Joe to work 24 hours on project x--only ot have him come down with the Flue and you have to assigne Mary to do the work in his place...)
Generally speaking, you should be able to create a summary report based on the table where you record worked or assigned and put fields from the related employee table in sub-summary parts. You can peform finds and sorts to control which records are included in the report (all records in the first quarter of this year for example) and how they are grouped. The trick is not to try this type of report in the employee table.
There can also be ways to get totals shown on a layout based on your employee table when you use aggregate functions such as Sum(), average(), count(), etc. in calculation fields defined in your employee table.
Here's a tutorial on summary reports that may help. It's based on a simplified invoicing system, but note how it bases a report on line items, but pulls data from the invoice table in sub summary parts.
First of all thanks for the information. I will take a look at the suggested tutorial.
To answer your question this is for planning work assignments only so I don't need to track planned work assigned against work actually performed.
Finally it sounds as though I should be able to use calculations (e.g., calculate % utilization of each employeebased on work assigned) within sub-summary parts. Is that correct?
Yes, but use care in defining them to avoid unexpected results.
a calculation such as A + B where A and B are simple number fields in the table referred to in Layout Setup... will be the value of one record in your database--no the entire groupl
If you do A/sTotal where sTotal is a summary field. sTotal will be the total over all the records in the found set--not the current subsummary group. To get the subsummary's subtotal, use GetSummary ( sTotal ; BreakField ) where BreakField should be the same field specified as the "sorted by" field in the subsummary part.