I have a multi-page form built for doing estimates, which functions on page as expected. It's somewhat complex with several computations, but seems to be working correctly. I'm passing the total for the estimates to the confirmation page.
I've noticed that if I add subtotals in the form to try to simplify the calculations, the formulas work on page and show the correct value, but they do not pass that value to the confirmation page if the subtotal field is used in the calculation. If I place the entire formula in the total field and completely avoid the use of subtotals as part of the calculation.. it works fine and passes the value.
This makes for a very long and complex calculation for the total and makes changes difficult since it's not done in stages. Is the inability to pass calculations using subtotals as part of the formula via merge fields an expected result? Or am I perhaps doing something wrong?
I also notice there is a three to sometimes several second delay between hitting the submit button and the rendering of the confirmation with totals... is this normal as well? The time it's taking makes me believe there is a problem somewhere and something is looping.
By the way... the calculations are all fairly simple adding and multiplication formulas... and maybe the delay is due to having a few dozen fields to add up and then do a percentage calculation on the total... but thats why I was hoping subtotals within the form might make it faster. Any thoughts?
