Skip to main content
Nov 11, 2024 2:55 PM UTC
Question

Expandable table total field calculation

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

radzmar
Level 10
Nov 21, 2024 5:54 PM UTC

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. 

Translate
Khushwant_Singh
Adobe Employee
Adobe Employee
Dec 6, 2024 5:42 AM UTC

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

Translate