Skip to Content
0
Former Member
Jun 04, 2008 at 01:41 AM

Probelms with totals

32 Views

Help! I am struggling on (I think is) the last leg of a report. My end result should be a report listing By department, By employee the labor efficiency based on tickets reported week ending. My problem stems in the fact that all labor tickets are identified by Type (I=indirect, S=Setup, R=Run), then if not an 'I'ndirect type, they are reported to an operation that is identified by 1)WorkOrder_ID, 2)LotID, 3)SeqNo. So I have my two tables (LaborTickets and Operations) left outer joined byfrom LaborTickets by Type, WorkOrderID, LotID, SeqNo. In my final report I have to group by Department and show one line for each EmployeeID. On the row must be: Indirect Time reported, Direct Time reported (Setup+Run) and Routed Time (if not a Indirect). Thus far I have Grouped by LaborTicked_EmployeeID, LaborTicket_WorkorderID, LaborTicket_LotID, LaborTicket_OperationSeqNo. In GH1 I have the EmployeeID, sum @Indirect. I can't seem to get a sum of the Routed time on this same line. GH2,3 and 4 have nothing and are supressed.

The details list first all the Indirect reported, then list the Operation_Setup, Operation_Run, LaborTiket_EmployeeID, LaborTicket_ResourceID, LaborTicket_ReportedDate, @WOLTID ( combines WO,Lot and Seqno), LaborTicket_OperationSeqNo, LaborTicket_Type.

GF3,2 and 1 are blank and are supressed.

In my GF4 I have WOLTID, Mode of Operation_Setup, Mode of Operation_Run, @TRTDtime (Mode ({OPERATION.SETUP_HRS}, {LABOR_TICKET.OPERATION_SEQ_NO})+Mode ({OPERATION.RUN_HRS}, {LABOR_TICKET.OPERATION_SEQ_NO}) which actually appears correct (can't sum the setup and run because the same op is listed several times in the details but there is only one total setup and run).

I just can't seem to get the grand total for all 'Routed hours' for the employee to appear on the same line (GH1). I know I can't sum the modes so I figured I would have to create a formula/field for ToNumeric them so they can then be summed. How would I do this in one field/formla? I am sooo close I can taste it. Please can any one help? Maybe I approaching this all wrong but I am close!

Thanks