Calculating Sum of all previous 'totals'

[Flynn0101]

I have a form that has many columns for inserting in description, quantity and price, of different items,

In this form, I want to have a total of all of the previously entered in prices to make a total price.

Im thinking of using a sum array but i dont know how to have the array change depending on where the total will lie.

Any help will be amazing

Thank you all in advance.

[Bernd Alheit]

What are the names of the total fields?

[Flynn0101]

Hello @Bernd Alheit 

The Total fields are labelled:

Total1

Total2

Total3

ect.......

Total40

[Bernd Alheit]

You can use following calculation:

[Asim123]

I think OP want something like dynamically total field, if  5 fields are filled he want total to be at 6th field, if 10 fields are filled he wants total to be at 11th field...etc

[Bernd Alheit]

This is possible with a script.

[Flynn0101]

@Asim123 
Thank you, Yes that is exactly right! Sorry if my explanation of what I was trying to achieve was sub-par.

@Bernd Alheit  @Asim123 

Do you think you would be able to point me in a direction in terms of the script I would use, or if you could send a link through to anyone else who has achieved this?

Thank you kindly for your responses 

Any information would be greatly appreciated.

[Flynn0101 · Accepted solution]

https://community.adobe.com/t5/acrobat/sigma-notation-in-adobe-acrobat-javascript/m-p/11884617#M3020...