Expand my Community achievements bar.

SOLVED

Sum of four tables in dynamic form

Avatar

Level 1

There will be a number entered in the last cell of each row which will total at the bottom. I've read and tried numerous ways to total the tables and none work for me. What am I doing wrong?

739931_pastedImage_1.png

1 Accepted Solution

Avatar

Correct answer by
Level 2

on the calculate event of the field you want to show the total, enter this code.

sum (Field1, Field2, Field3, Field4)

replace the "Field" parts with the desired fields. when entering the code ctrl+click the sections you want to calculate and separate them with a comma. This will get the absolute name for the objects to be referenced.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

on the calculate event of the field you want to show the total, enter this code.

sum (Field1, Field2, Field3, Field4)

replace the "Field" parts with the desired fields. when entering the code ctrl+click the sections you want to calculate and separate them with a comma. This will get the absolute name for the objects to be referenced.

Avatar

Level 1

Yes, it does work - thank you! I was about ready to go out of my mind