try putting $ = before your sum:$ = sum (rrtotal, programtotal, financetotal, lead.....

level is showing as IV because tpe is 0. The code above does not change tpe so I am not sure why is has ruined your calculation. Can you post what you have in your calculation event?

you can put that code in the calculation event of tpe after the code you already have to work out the value of tpe

in the exit event of "tpe" put:if ($ > 1000 and $ <= 1985) thenlevel = "I"elseif ($ > 850 and $ <= 1000) thenlevel = "II"elseif ($ > 550 and $ <= 850) thenlevel = "III"elseif ($ <= 550) thenlevel = "IV"else level = ""endif(this assumes the user is entering the amount in the tpe cell. If it is worked...

Is there any other code in or relating to TextField2?

try putting in the docReady event of TextField2:$ = TextField1.rawValue

you need another endif at the end (you have a nested if statement and only 1 endif)

You have a table within a table so maybe check for the rows/table within each one

the repeating rows when you reopen the form probably have something to do with the binding. Under Object > Binding just make sure the 'Repeat Row for each data item' box is only clicked on the actual row you are repeating and not the whole table.

Were you using java or formcalc when you got the error? I recreated your table and the code works in formcalc.In regards to the insertIndex working in the first row I think that may be because you are always referencing the first row (R_Activity).