I have a sub summary with three fields; sumqty, serial_qty, and reject_percent.

sumqty is a summary field which is a total of the "qty" field.

serial_qty is a calculation field that basically looks up a value from another table.

reject_percent is a calculation field that = ( sumqty / serial_qty )* 100

In the report, the sumqty and serial_qty are correct and change according to how the report is sorted. The reject_percent, however, always calculates based on the sumqty of EVERYTHING in the table.

For example:

sumqty | serial_qty | reject_percent

340 | 4605 | 693%

When I look in the at all the records in the table the sumqty shows 31936 for all the records which is what I would expect. But when I create a report and sort the fields should't the calculations be broken up into those sub summary values?

Thanks so much for the help!

Use the GetSummary() function.

Use the GetSummary() function.

Where do I use it?

In your calculation field - instead of using the summary field directly.

Thank you Comment!!!!