Formcalc on table (yes i've looked at other discussions and can't apply their response)

[leoraulroldan]

PLEASE HELP!!!

i have a table. 5 columns. 25 rows including header & footer rows. i would like to calculate totals of each column.

the formulas i've tried are:

sum (Table2.Row[*].Cell2[*]) NOTE: this is to calculate all the rows in 2nd column with name 'Cell2'.

i seem to be able to get row1 only when i use the following:

sum (Table2.Row1[*].Cell2[*])

[Bibhu_Bikash_Na]

Hi,

In the total column of each row you can directly put the following script.

Cell1+Cell2+Cell3+ .....

Thanks.

Bibhu.

[radzmar]

Hi,

the question is: What's the name of your rows?

Your first code says "Row[*]", which indicates you wanna try to resolve all instances of the rows named "Row".

The second on says "Row1[*], which means all roaw named "Row1".

To get your first script working you have to rename all rows to "Row", so the hierachy will show "Row[0], Row[1], Row[2]...".

Then the script is able to resolve those instances [0], [1], [2]... with the [*].

The next thing is "Cell2[*]".

If there is only one instance of Cell2 in each row, you don't need the [*].

This is enough:

sum (Table2.Row[*].Cell2)

radzmar

http://thelivecycle.blogspot.com/

[leoraulroldan]

Hi there,

thanks for your response, how do you rename the rows???

[radzmar · Accepted solution]

In the workspace of Designer you have a hierarchy windows to the left.

There you can see yout form structure with all subforms, tables, rows, form fields etc..

Select the desired object and press F2, then you can rename it.