You can try the following..
1) Keep the same name for all the amount fields in each column. (for example, first amount column field name is "Amount1" and second column field name is "Amount2").
2) Then write the code in the Calculate event of the Total field. (Use FormCalc)
Total1.rawValue = Sum(Table1.Row1[*].Amount1);
3) Similarly for Second column
Total2.rawValue = Sum(Table1.Row1[*].Amount2);
4) For the total of Amount1 and Amount2.
LoanTotal = Sum(Total1.rawValue + Total2.rawValue);
Hope this helps.
Thank you Srini for answering. Here is the formula that is working.
Field Name - TotalA1:
Sum(Table1.Row1.A1, Table1.Row2.A1, Table1.Row3.A1, Table1.Row4.A1, Table1.Row5.A1, Table1.Row6.A1, Table1.Row7.A1, Table1.Row8.A1, Table1.Row9.A1, Table1.Row10.A1);
Field Name - TotalA2:
Sum(Table1.Row1.A2, Table1.Row2.A2, Table1.Row3.A2, Table1.Row4.A2, Table1.Row5.A2, Table1.Row6.A2, Table1.Row7.A2, Table1.Row8.A2, Table1.Row9.A2, Table1.Row10.A2);
But this is not working
Field Name TotalLoanAmt:
Sum(FooterRow.TotalA1 + FooterRow.TotalA2)
Any idea how I can get the grand total working? Thank you. Deepa
The only issue I can think of is referencing the proper path.
Check the path of the field in the Heirarchy or in the Script Editor.
(or) Paste a screen shot of the heirarchy of the form to get a better understanding.
Try just "Sum(TotalA1 + TotalA2)" and see what happens..
Give a proper name for each Footer Row.. (For ex: FotterRow1, FooterRow2)..
Then your code will work without much complications.
Sum(FooterRow1.TotalA1 + FooterRow2.TotalA2)
For the Amount fields set the Fonts to Right align to have a good look and feel..