Trailing Grand Summary Summing last date
I'm working with a report in FM Pro Advance 13.0v3. I have a report that is using the Date of service as the break field. In the sub-summary field I have quite a few fields. Looks like this......
My problem is my Trailing Grand Summary is showing totals in the C_(calculation fields) from the last date of service, where my S_(summary fields) are providing the correct summary of all the dates. The calc fields get summary calc for the first two summary fields to get the difference then the %. So my guess is that the trailing grand summary will not work unless it is a summary field. So Then I created summary fields of the calc fields and placed them in the grand summary and that still didn't work.
Is there any way I can get these summaries to work in the current format? or will I have to redesign?