Counting or Suming Distinct Values

[SteveE]

I have a report which groups together various data, ContainerID; Order No; BoxCount; Part. and Units etc
Each BoxNo should be unique BUT when 2 different units are assembelled in the same box I will get a repeated BoxNo in the data I import

ie
Pallet ID Order # Part # Product Description EAN # PO # Box No Unit Qty
SHIPS001098542 049810586 P6731 Consumable 5391519384329 358269 63 1
SHIPS001098542 049810586 M6935 Consumable 5391519384336 358269 63 1

I need to be able to sum / count by distinct box numbers in my report so in the above example I would have a 1 box with 2 units.
How can I do this in a report ?

 

[llkhoutx]

Create the sum in the report footer.

 

[SteveE]

thanks but I have the sum there but it will still count box 63 twice as this box number is in the imported data twice. I want the count to count distinct numbers ie 63 only once .
regards
Steve

 

[llkhoutx]

You're summing with too many non-unique columns.