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

Avatar

Level 2

I am using sum the following script

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

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?

0 Replies

Avatar

Level 10

Hi,

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.

Regards

Bruce