I am having trouble trying to calculate the sum of text fields that are a result of calculations run in a repeating group.
I have a repeating group that is running a calculation to show the total line item price for items in a users shopping cart, and at the top of that order summary I want to displaythe total price for all of the items in their order. So each row in a repeating group is a product, and within that row is a text field that dynamically calculates the cost for that item in your order (product price x quantity desired). This all works fine.
The problem, is that I cannot figure out how to show right above the repeating group the total price of all of the products they want at the quantities they want them at. This would be easy if I could just summarize the number values of dynamic fields in the repeating group but I have not found any way to do this.
Please help me! Does anyone have any ideas on how to calculate this value?