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
BedrockMission!

Learn more

View all

Sign in to view all badges

Calculating a total of a column Livecyle EC2

emmad11800879
Level 2
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?

1 Reply
_Bruce_Robertson
Level 10
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