Grand subsummary problem

[john9210]

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?

[Brett W]

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.

[bcooney]

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).