9 Replies Latest reply on Jan 5, 2012 2:33 PM by philmodjunk

    Use Trailing Grand Summary data in other calculation??

    arronman

      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?