Newbie needs help translating error message

[Former Community Member]

I'm a new user, and I've designed an order form with two tables and a calculated subtotal for the two tables.



The tables are identical except for the values in drop down lists. I'm trying to sum the values for the ExtPrice field, which the script editor shows as named this:



----- form1.#subform[0].Table1[0].Row1[0].ExtPrice::calculate: - (FormCalc, client) ----------------



So using that information, I summed the values in all six rows of both tables using this formula:



sum(Table1[*].Row1[*].ExtPrice[*])



When I switch to preview pdf, the field calculates just like I expect it to, however I get this message when switching to preview mode:



"Script failed (language is formcalc; context is

xfa[0].form[0].form1[o].#subform[0].Table1[1])

script=sum(table1[0]Row1[*].ExtPrice

Error Syntax error near token 'Row1' on line 1 column 17"



Yeesh. the tables are named "Table1[0]" and "Table1[1]" and I tried summing the field on just one table and still get the same error (but the form works).



Can anyone help me translate this so I can fix the form before distributing it to users?



Dave in Michigan

[Former Community Member]

Looks like you are missing a dot between the table1[0] and the Row1[*]. I t=hink it should read:



sum(table1[0].Row1[*].ExtPrice)



This command will effrectively all all of the fields called Extprice in all occurances of the Row1 subform in the Table1.