Calculating totals for multiple columns

[deepap19us]

I want to add totals for two columns in a table and a final total with those two subtotals. I can not figure out how to do this and how to reference the rows and cells. Can someone please help? Thank you. Deepa

[Srini_Dhulipall]

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.

Thanks

Srini

[deepap19us]

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[0].TotalA1 + FooterRow[0].TotalA2)

Any idea how I can get the grand total working? Thank you. Deepa

[Srini_Dhulipall]

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..

Thanks

Srini

[deepap19us]

Here is the screen shot

[Srini_Dhulipall · Accepted solution]

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)

Thanks

Srini

[deepap19us]

You are the best. Thank you so much. It is working now. Deepa

[Srini_Dhulipall]

For the Amount fields set the Fonts to Right align to have a good look and feel..

Thanks

Srini