Duplicate WO Qty Added To Sum From WO Qty

[bstafford21]

Using CR 9.2
I have a report that displays in Columns all Details Data of Daily Work Orders. The Detail Database's are:

Materials
Ops
Part
WO

Everything works perfect exept for the totals in the Group and Report Footers.

I need to have a daily summary of Parts Stored and Material used for each type of material, some materials used numerous times during the shift. This is the layout but goes across in column form.

Date (Ops.Date_of_Completion)
WO (WO.WO_No)
Part (WO.Part_No)
Material (Materials.Part_No)
Mat Iss (Materials.Qty_Issued)
WO Qty (WO.Qty)
Qty Stored(WO.Qty_Stored)
Qty Scrap (WO.Qty_Scrap)
Price (Part.NormSellingPrice)

Have Created a Group Footer Formula for the following:

Scrap Cost(@Scrap Cost) using {Part.Norm Selling Price}*{WO.Qty_Scrapped}

Produced Cost(@Produced Cost) using {Part.Norm Selling Price}*{WO.Qty_Stored}

Total Scrap % (@IndividualScrap%) using if {WO.Qty_Scrapped} = 0 then 0 else 100-(({WO.Qty_Stored}-{WO.Qty_Scrapped})/({WO.Qty_Stored})*100)


I have a Daily Group for each day using Ops.Date_of_Completion.

Now all my Production Totals are grouped for each day showing me the totals using the Insert Summary for Qty Stored and Qty Scrapped. This is in the Group Footer

I also did a Sum of @Produced Cost which has duplicated Sales figures.

My problem is there are some WO.WO_No listed 2 or 3 times for some parts. This is due to the material used from the (Materials.Qty_Issued),

These WO's sometimes have 2 or 3 different materials to make a part. These are the WO.WO_No's that are duplicating in the Sum of WO.Qty_Stored and Sum of @Produced Cost and Sum of WO.Qty_Scrapped. I need to not count these again, only once.

I also am using a Grand Total Summary in the Report Footer.

Sum of WO.Qty_Stored
Sum of @Produced Cost
Sum of Wo.Qty_Scrapped
Sum of @Scrap Cost
@Scrap % Ration

These will also have duplicate WO figures as well, do I need to modify these formulas as well so not to duplicate date from the WO's?

My second area I need to do is how much material for each materials used by each WO.Part was Issued.
I need a Sum of each Material, because not all the same material is used for each WO. How do I do this?

Thanks for any help and I hope I have given enough information to solve this. I appreciate anyone's time.

Thanks

Bill

 

[MisterMo]

You could try by using running totals and place selective formulas to meet your needs

Mo

 

[bstafford21]

Hi Mister Mo,

Thanks for the help and suggestion. I now have tried that using Running Totals and it solved my problem.

Thanks

Bill