Expand my Community achievements bar.

Adding a row error


Former Community Member
I have built a table to calculate expenses in a seperate subform I have an associated add item button. The button adds the required extra line but does not add the exsense item to the total - in addition if gives the following error:

script failed (language is formcalc; context is


script = Table1._Row1.addInstance(1)

The calculation I included in the table is as follows

if (exists(Row1[0].expense) ==1) then



I would be really grateful if someone could help me solve this error and ensure my expenses calculate correctly. The rest of the form functions well.

2 Replies


Former Community Member
There is an example that does this already .....have a look at the Purchase Order in this location:

EN\Samples\Forms\Purchase Order\Dynamic Interactive\Forms

It does exactly what you want.


Former Community Member
Thank you for the help - it is now working.