Getting the sum in FormCal

[Tmeeks271]

Please help!!!!

This is driving me crazy. I have created forms in the pass and simple math expressions have worked.

Here's the problem. I have created a table with 6 rows and 6 columns. I can make the rows do simple mathematics, however I can't get the columns to give me the SUM of each row. As you see the error I keep getting below. I have tried FormCal Sum(sq1, sq2, sq3, sq4, sq5, sq6) and I keep getting the same error. Does anyone know what I'm doing wrong? I would appreciate the help.

Thanks,

[whyisthisme]

It is not working becuase you need to reference the rows in the sum function. So it should be something like this:

Sum(Row1.sq1 + Row2.sq2 + Row3.sq3) etc

You can make it easier for yourself by naming all the rows the same thing (eg. Row1) and all the total cells the same thing (eg. Total) then it will automatically rename them Row1[0], Row1[1], etc.

Then for the sum of the columns you just need to put Sum(Row1[*].Total).