Calculate Total Cost for Regenerating Numeric Field

[avargs]

Hello,

I had a question about calculating a total cost for this form I have.

The only difficulty is that the field "cost" that I am trying to sum up is part of a subform that is regenerated at the click of the button.
The other part of the form includes "total cost" field is part of another subform that is fixed.

Ideally, this subform is replicated about 4 times which would mean that the grand total cost would have to sum up the 4 cost fields(3 of them were generated).

I have an example form that I can share via e-mail to help clarify the question.

Thanks,

-vargs

[Former Community Member · Accepted solution]

There are nice features in FormCalc for this. You can use the Sum function and refernce all objects of the same name by using a [*] syntax. So if your field Cost is in a repeating subform called Row the expression woudl be Sum(Row[*].Cost). This would add all of the Cost fields in all Rows (whether there are 2 or 50 ).

Hope that helps

Paul

[avargs]

Thanks so much Paul,

I applied the code and it worked perfectly.

Your answers are always clear and concise and I appreciate your help.

-vargs