Calculating a total of a column Livecyle EC2

Avatar

Avatar
Boost 1
Level 1
emmad11800879
Level 1

Like

1 like

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
emmad11800879
Level 1

Like

1 like

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
emmad11800879
Level 1

24-11-2016

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Establish
MVP
_Bruce_Robertson
MVP

Likes

271 likes

Total Posts

1,782 posts

Correct reply

372 solutions
Top badges earned
Establish
Give Back 25
Give Back 10
Give Back 5
Give Back 3
View profile
_Bruce_Robertson
MVP

25-11-2016

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