I am having trouble adding up a column of text boxes. Plse help

S

steinerdf

I am new to infopath. I am putting together a form for an employee that
enters the same data for several employees. I have most of it done, but am
having big problems getting a sum of text boxes value together. The text
boxes contain info from a formula from entered values. Help!!!
 
S

Shiva[autonomysystems.com]

Hi steinerdf,

I am trying to give you an example to solve your problem.

Create just a normal order sheet with fields for price, discount and
subtotal in a repeating table. At the bottom of the table create a grand
total of all the rows together. Now the grand Total will be the sum of all
the subtotals in the table. (I suppose you are trying to do the same)
For the subtotal field set the Default value as number (Price) - number
(Discount). This will give you the sub total value for each row. Now in the
grand total field set the Default value as sum (subtotal).
What sum does is, it returns the sum of all nodes in the Node-set. Therefore
your Grand total field will be the sum of all subtotal fields.

Work out this example, if it doesn’t solve your problem get back to me again
with more details.

Hope this Help you..
 
A

Adam Harding

Select the properties of the field, then click the 'fx' icon to the right of
the flashing icon then select the first field you wish to add the value of by
going into 'insert field or group'. Then AFTER the field press 'SPACE' then
add a '+' then another 'SPACE' and insert another field and so on. Does this
help?
 
Top