I have a form with fields that I would like to have subtracted. The way that I had them set is not working..It's adding them instead...the field name(s) are as listed in the Hierarchy:
amt amt total_amt
amt_1 amt_1 total_amt
I want to take amt and subtract amt from it to get total_amt. I was using the code sum(amt[*])...Of course, that was addition...Can't figure out how to make them subtraction. Once I get this figured out I want to take the row total_amt (and , etc) and add those. For some reason sum(total_amt[*]) is not working for me. Can this be done?