2 Replies Latest reply on Jan 26, 2010 2:05 PM by SimonC

    Subsummary Totals show Trailing Grand Total

    SimonC

      Title

      Subsummary Totals show Trailing Grand Total

      Post

      Hi,

       

      Using FM10 with Mac OS 10.6.2  I'm trying to build a monthly sales report. It reports sales and tax, separately, on a daily basis into a subsummary using summary fields.  It also reports the month's total in a Trailing Grand Total using summary running total fields.  All well and good.  However, I also want to report the gross daily total of sales + tax.  Despite having tried by creating several different calculation fields in the same subsummary, defining the field total as being equal to daily sales and daily tax, the total reported is that of the whole month.

       

      Is there any clearing of field values that could/needs to be done for this to report correctly?

       

      Thanks Simon