Hi, I want to do a simple multiplication between a quantity field time a unit price field in a repeating section then have a line total, then add a row and do the same thing again. I want to add all these line totals into a single total amount. I've been trying but have been unable to make it work. I've done this in the classic form. Anyone has an idea on how to do this? Thanks.
add a calculated field in the repeating section that will do the math part and use a rule to hide it and give it a name (make sure all your controls within the repeating sections have names to reference it in the calculate field)
now outside the repeating section add another calculated field with function in it you will use SUM runtime function and between the brackets add your calculated field that was inside the repeating section