Calculation by Sub summary

[Reid]

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!

[comment]

Use the GetSummary() function.

[Reid]

Use the GetSummary() function.

Where do I use it?

[comment]

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

[Reid]

Thank you Comment!!!!