I have a line item order form I'm working on. There are seven lines in which the user can entered their quantity/unit cost/etc. I've set everything up to calculate the total cost for each line (last column on the form), and then these total costs are summed as the sub total at the bottom of the form. This works beautifully. The problem is I think I need a custom code to sum the sub total at the bottom of the form EXCEPT when there is only one total cost value on the form in which case the sub total field should just grab that with no calculation. I hope this makes sense? Thanks for any help you have!
If Total CostRow2 = 0 then Total Costsub total = Total CostRow1
Otherwise, Total Costsub total = sum of Total CostRow1 -> Total CostRow7
I hope this helps clarify.
No, there's no need for any special calculation. If you sum multiple fields and only one of them has a value the result will be identical to the value of that field.
My guess is that your field calculation order (NOT the same as the tab order!) is incorrect.
You can set it in Form Edit mode, under More (or Other Tasks, depending on your version of Acrobat).
This is very helpful. Thank you!