Expandable table total field calculation | Community
Skip to main content
November 11, 2024
Question

Expandable table total field calculation

  • November 11, 2024
  • 3 replies
  • 771 views

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

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Level 2
November 11, 2024
radzmar
Level 10
November 21, 2024

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. 

Khushwant_Singh
Adobe Employee
Adobe Employee
December 6, 2024

@sergiuba1 , Did you try the suggetion provided by @radzmar ? did it resolve the issue for you?