This question was posted in response to the following article: http://help.adobe.com/en_US/livecycle/10.0/DesignerQuickStartTutorials/WS92d06802c76abadb6fe0558212a...
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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!
Views
Replies
Total Likes
Great to know that you are now able to resolve your concern.
Views
Replies
Total Likes
Views
Likes
Replies