I think I'm missing something very simple here... I could probably write a formula without too much trouble, but it seems like this should be a built-in function. I'm using CR 7.
I have a report that lists job steps for a work order. For each work order I show the total trench footage and total hours charged, and then start date and end date for each job step associated with that work order.
What I want is a total of the trench footage and hours charged for all of the work orders. What I'm getting, though, is the total of trench footage (or hours charged)for each job, multiplied by the number of job steps.
In other words, if a job has 100 TrenchFt and 200 HrsCharged, and then three job steps associated with it, 300 TrenchFt and 600 HrsCharged are reflected in the totals - although the report only shows the TrenchFt and HrsCharged on the Work Order level.
I can get the count of work orders very simply using the 'distinct', but I can't figure out how to get the correct numbers for TrenchFt or HrsCharged.
What am I missing? Apologies if this is something ridiculously simple that I'm overlooking. I've tried searching for similar previous questions and haven't found an answer.
Here's a quick idea of what the report looks like. Grouped on RespPerson, then WorkOrder. TotalFt and TotalHrs should be a simple summation of the TrenchFt and TotalHrs for each Work Order.
RespPerson TotalFt TotalHrs
WorkOrder#1 TrenchFt HrsCharged
JobStep1 StartDate EndDate
JobStep2 StartDate EndDate
JobStep3...
WorkOrder#2...
JobStep1....
Thanks!
-Karyl