Table Sums for Recurring Tables in AEM Designer/Livecycle
I am working on creating a personnel budget in AEM Designer and built the table out with buttons to add/remove an instance of the table for each position. I wrote script for each "Totals" cell to sum up (or average %) in the gray cells, however in the bottom "Totals" row pulls the same figures from the Position 1 table into the "Totals" row on the Position 2 table and so on.
Here is the example script I have for the Annual Budget Year 1 (CY 21) Totals cell:
$= HeaderRow[4].Position1CY21AnnualSalaryBudget[*]+HeaderRow[5].Position1CY21AnnualFringeBudget[*]

Can someone help me troubleshoot why each instance of the table is pulling totals from only Position 1
