Reid Posted January 31, 2011 Share Posted January 31, 2011 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 More sharing options...
comment Posted January 31, 2011 Share Posted January 31, 2011 Use the GetSummary() function. Link to comment Share on other sites More sharing options...
Reid Posted January 31, 2011 Author Share Posted January 31, 2011 Use the GetSummary() function. Where do I use it? Link to comment Share on other sites More sharing options...
comment Posted January 31, 2011 Share Posted January 31, 2011 In your calculation field - instead of using the summary field directly. Link to comment Share on other sites More sharing options...
Reid Posted January 31, 2011 Author Share Posted January 31, 2011 Thank you Comment!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4834 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 accountSign in
Already have an account? Sign in here.
Sign In Now