Jump to content

Calculation by Sub summary


Reid
 Share

This topic is 4390 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

This topic is 4390 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.