Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!

GRAND TOTAL ON PAGE 3 OF DOCUMENT

Avatar

Former Community Member
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
2 Replies

Avatar

Former Community Member
can anyone help please I need to get this in today if possible

Avatar

Former Community Member
Kathie Reed,



This forum is for questions on Adobe's
Solution Accelerator SDKs. The
LiveCycle Designer ES forum would be a better place for this thread.



That being said, assuming you have amount1 on page1 and amount2 on page2, you can get amount3 on page3 to show the sum of amount1 and amount2 by setting its Calculate script to this, in FormCalc:





SUM(page1.amount1, page2.amount2)




Stefan

Adobe Systems



More answers at
Stefan Cameron on Forms.