Duplicated Data

[bstafford21]

Hello All,

I have an issue with using the Sums formula and getting results that are doubled.

The reason for this is due to my report data having 2 lines for each item, there is material we use for this and this is correct for the data. Because of the requirement I use as the reference an item called Work Orders, each Work Order I have in the "DETAIL" will list for me the amount of material needed to make this part. What also occurs is for the Work Order it will tell me how many boxes I need to package it.

Since 2 items occur on some of these Work Orders, then the material is also listed twice, hence the sum formula will add both amounts, how do I prevent the material from adding up twice for each Work Order? Is there another formula I can use to not just suppress it, but to delete the duplicated detail I do not need?

I am now using a formula to suppress the display that is duplicated and this hides the additional material amount that is pulled into the report, but suppress it by using the following formula:

previous({WO.WO No}) = {WO.WO No}

This of course works very well, however when trying to get a sum for this material usage column, it adds the duplicated item that I suppressed, but the sums formula will still add the duplicated amount.

Is there an additional filter formula I can use in the sum formula so it only adds the material for each Work Order, only want it to add once, not twice if I have duplication.

Thanks for any help, I appreciate this forum alot and each person time to respond.

Cheers

Bill

 

[IanWaterman]

Use a running total instead of a sum.

Base it on your existing amount field but in the evaluate set it to change of work order, then it will only do it once.

Ian

 

[bstafford21]

Hello Ian,

Thanks for the help on this, I will try this now and get back to you whether it works for me or not.

Cheers

Bill