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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Getting the sum in FormCal


Level 2

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.



1 Reply


Level 7

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).