Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculating a total of a column Livecyle EC2


Level 2

I am using sum the following script


to total 28 rows in a column however the script only seems to work on Row1 - I am not sure what I am doing wrong -

I am using formcalc and each cell is labelled 'amount' and is a numeric field.  The script is entered in a numeric field labelled Total.

I feel I am missing something simple but not sure what.

Can someone help?

1 Reply


Level 10


I think you need, sum(Table1.Row1[*].amount), that is without the final "[*]", as the amount field doesn't repeat in the same way as Row1 does.