let's start with a screen capture:
Each line are summaries by week for some numbers but for the last one That works fine. But have issues with some of the Grand Totals on the last line (Trailing Grand Summary). The numbers in the yellow box are fine, but in the red box they are wrong.
The numbers on the summary part (yellow box) are summary fields that are Total of respective fields. Numbers for summary part in the red box are calculation fields calling GetSummary().
For the yellow box, same fields are set on the Grand Total part, they work as expected. In the red box, at first I also set the same fields as on summary part, but got the same value as on the last line. I changed that to Summary fields at Total of respective fields on summary parts. Numbers are wrong, my guess is that I get total for all fields in the database .
I hope my explanations are not too confusing. So the question is: how can I get correct Grand Totals for the columns in the red box ? I thought of using Execute SQL(), but maybe there something more à la FileMaker to achieve the result.