AnsweredAssumed Answered

Trailing Grand Summary Summing last date

Question asked by CaseyIssac on Dec 18, 2014
Latest reply on Dec 18, 2014 by philmodjunk

Title

Trailing Grand Summary Summing last date

Post

Hello,

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?   

FM_Trailing_Summary.PNG

Outcomes