Expression Boxes

[SeanM]

I have multiple repeating tables that I am using within a form. At the
moment, I have them totaled with expression boxes for each table. I also
would like to have a grand total at the end. Can you add multiple expression
boxes together? If not I heard that you can use text boxes to add boxes
together. If so, how do I do that?

 

[Andrew Watt [MVP - InfoPath]]

I have multiple repeating tables that I am using within a form. At the
moment, I have them totaled with expression boxes for each table. I also
would like to have a grand total at the end. Can you add multiple expression
boxes together? If not I heard that you can use text boxes to add boxes
together. If so, how do I do that?

If your sum for section 1 is
sum (... field1)

and your sum for section 2 is

sum(...field2)

then your grand total in an expression box is simply

sum(...field1) + sum(...field2)

The ... means "the rest of your XPath goes here"

Andrew Watt
MVP - InfoPath

 

[ewaa]

I have the same problem. The thing is that fields become something else once
you use the expression box. Yeah, the idea would be to sum, subtract, devide
or multiply multiple expression box or some how allow the fields to remain
fields even after expressions box are apply.