Inserting the subtotal at the bottom of the table

[community_help]

This question was posted in response to the following article: http://help.adobe.com/en_US/livecycle/10.0/DesignerQuickStartTutorials/WS92d06802c76abadb6fe0558212a...

[hellothere111]

Any ideas on how to sum a column of numbers? Where you have two rows like this:

NumberOrdered1 Price1 Amount1

NumberOrdered2 Price2 Amount2

Where: NumberOrdered1 * Price1 = Amount1 etc

I want a total at the end of the page that equals Amount1 + Amount2

[pranavj326318]

Hey hellothere111,

As you are working in a Table, you need to provide the complete path e.g(row.fieldname)

in your case please try the script (Formcalc)

Row1.Amount1 + Row2.Amount2

Let me know if it helps.

[hellothere111]

Thanks Pranavj. That makes sense, especially with two pages of rows. I tried using Row1.Amount1 + Row2.Amount2 and that still created an 'accessor Row1.Amount1 is unknown' error, so I tried adding in a little more, Table1[1].Row1.Amount1 this stopped the error message but didn't update the total. I also added subform[2].Table1[1].. and #subform[2].Table1[1].. both created an error. Adding a little more, form1.#subform[2].Table1[1].Row1.Amount1 again removed the error but didn't update the total until...  I figured out that the Caption and the FieldName cannot both be "Subtotal". I changed the field name to SubTotal and your advice works great.

Thank you!

[pranavj326318]

Great to know that you are now able to resolve your concern.