July 26, 200718 yr 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?
July 26, 200718 yr 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.
July 26, 200718 yr 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).
Create an account or sign in to comment