Expand my Community achievements bar.

Expandable table total field calculation

Avatar

Level 1

Hello everyone,

I have been trying all day with gemini and chatgpt - no code provided works - to calculate a total field by summing all the cells above.

The rule have to be that the value to automatically be calculated bases on the rows and values from the table.

Honestly, at this point I am stucked.

I am posting some screenshots to be more specific.

 

I will appreciate any help from a more experienced member.

 

With all due consideration,

Sergiu

SergiuBa1_0-1731336750844.png

SergiuBa1_1-1731336813182.png

 

 

2 Replies

Avatar

Level 10

Hi,

 

to sum the cells of the repeated Row1 add a FormCalc script into calculate event of the sum field: 

$ = Sum(Row1[*].FieldName) 

 

Instead of FieldName use the real name of the field in your form. I don't know how you named it, since your screenshot doesn't show it.