john9210 Posted July 26, 2007 Share Posted July 26, 2007 FM 8.5 adv. I have a calculation GetSummary field in a subsummary part. I need to total it in the grand subummary part. I've tried summary and getsummary calculations but nothing works. They don't total properly . Is there any way I can do this? Link to comment Share on other sites More sharing options...
Brett W Posted July 26, 2007 Share Posted July 26, 2007 Hi, Might want to try using a SUM() function in the sub-summary to get your totals there, then in the trailing grand summary, use the Summary field to get your total of all the SUM calculations. Link to comment Share on other sites More sharing options...
bcooney Posted July 26, 2007 Share Posted July 26, 2007 Use a calc to sum any child records. Then in the parent, use a summary field to total the calc. Place the summary field in the sub-summary part and grand summary part. Remember to set the sort order to match the order of the sub-summary part(s). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6118 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