2 Replies Latest reply on Jan 6, 2009 8:30 AM by StefCameron

    GRAND TOTAL ON PAGE 3 OF DOCUMENT

    Level 1
      I have a order form, the first page is totaling fine for that page and the total on that page is called amount3 totaling all amount 1's, this is a interactive form. and I am using calcform

      Page 2 is also totaling correctly for page 2 but only page 2. the total box is called amount2 and it is totaling anything in the amount1 also.

      page 3 I would like to have it total all three for a grand total and it is not.

      here is what I am using for the first two pages
      SUM(AMOUNT1[*])

      here is what I have used on page 3 based on some of the other answers but something is not correct

      ----- scrip.Page3.GrandTotal::calculate: - (FormCalc, client) --------------------------------------

      sum(AMOUNT3,AMOUNT2,scrip.PAGE1.scrip.PAGE2)
      can anybody help a example would really help or tell me exactly what to do I am new at these formulas, excel I can do in my sleep but this I am not at all sure about.

      thanks
      Kathie