AnsweredAssumed Answered

Use Trailing Grand Summary data in other calculation??

Question asked by arronman on Jan 4, 2012
Latest reply on Jan 5, 2012 by philmodjunk

Title

Use Trailing Grand Summary data in other calculation??

Post

Hi All,

I have a report which selects data from records sorted from a range of dates.  Works perfectly after help from the Filemaker Masters (grovel, grovel!).

Now I want to use data from a traiing grand summary (which gives the grand total of  summary fields [running with restart]) in a separate calculation field.

I have set up a simple calculation in which I want to use the trailing grand summary. I can easily use the summary field, but this does not give me the grand total, as there is not a separate field for it, but merely the last iteration of a summary by date.

How can I set up a calculation which uses the (treailing grand) total of the summary field after it has been limited by a sort?

Outcomes