Issue with Calculated field that utilizes a summary field

[NickFaraday4]

I'm having some issues with a calculated field....

I have a bunch of invoices with line items each line items has a number of boxes the items come in. I have a summary field that gives me total number of boxes in an invoice. Next I have a calcualted field that determines the number of pallets a given invoice will require based on the summary field.

When I put these fields into a sub-summary based on Invoice ID the summary of boxes field works correctly, but my pallet calculation gives me the total pallets for every invocie in the review. (IE its calculating based on the total boxes in the found set)

Not sure what going on here...

An example of my report (where you can get 4 boxes per pallet)

What I get:

Invoice Boxes Pallets

123 16 9

232 8 9

838 12 9

What I want:

Invoice Boxes Pallets

123 16 4

232 8 2

838 12 3

[comment]

Use the GetSummary() function.