Expand my Community achievements bar.

Script to calculate column total in a dynamic table

Avatar

Level 4

Does anyone know of a script that will calculate the total of a series of cells in a column (e.g. Auto Sum function in Excel) when the column is part of a dynamiclly growing table? 

Thanks in advance,

Jenny

1 Reply

Avatar

Former Community Member

Use Form Calc ..... assuming the column field names are called Total then you would use Sum(RowName[*].Total)

Paul