grandTotal for multiple pages - very desperate

I have a multiple page report for our church in livecycle using formcalc. I have a subtotal on each page.

the formula for the subtotal is:
----- SCRIP.Page2.Table1.Row1[0].Amount2::calculate: - (FormCalc, client) --------------------------

sum(Table1.Row1[*].AMOUNT[*])

the name in the binding for this is on page1= Amount1
page2=Amount2
page3=Amount3

so for the grandTotal my formula is

sum(Page1.Amount1, Page2.Amount2, Page3.Amount3)

this is the error I receive: error accessor 'Page1.Amount1' is unknown

can anybody please tell me what I am doing wrong... I have been trying to find the answer by reading thru some of the questions but not finding the answer and I have been working on this for weeks and need it in to our church. thanks for all and any help.

the hierarchy shows Page1 and Amount1

Thanks

Kathie