Sumamary fields on report

[Philby]

Hello,

I am having an issue with a report using summary fields.

I have a series of transactions to various work orders.

My report looks like below

Work Order#-----WO Quantity----Usage(lb)

123-----------------1000------------5

123-----------------1000------------3

123-----------------1000------------1

125------------------500------------5

125------------------500------------2

If I summarize the WO Quantity, I want to get 1500 because there are only two work orders with 1000 and 500 ea.

Right now it's giving me 4000 because it is totaling all the lines.

I've tried playing with all the summary total settings, but it always gives me 4000. Even if I do a sub-summary of the work orders and total the quantity fields.

Any ideas?

Thank you,

[comment]

Try something like this:

sCountItems = Summary ( Count of TransactionID )

cQtyShare = WO Quantity / GetSummary ( sCountItems ; Work Order# )

sTotalQty = Summary ( Total of cQtyShare )

[Philby]

Excellent! It worked perfectly.

Thank you very much