Begginer Infopath 2003 - How to calculate values in rows and colum

[Maynard]

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[JerryTh [MSFT]]

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?

 

[JerryTh [MSFT]]

Actually, the text box doesn't have to be in the footer. It can be anywhere
on your form
Sorry about that...
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[Maynard]

Thanks Jerry.

Here's what I did.

1. I have a repeating table with one row ( income 1, income 2, income 3)
then a subtotal at the end of the row.
2. Followed your steps from 1 to 5.
3. Can't find/see my subtotal. How do I expand my data source?

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[Maynard]

Thanks Jerry. I do have another question aside from calculation. In adding a
submit button, I know how to send or route it to a particular person via
e-mail. What I want to know is how to program the submit button by:

1. Sending it via e-mail with a blank To: CC: Bcc: (it's like an automatic
Send as attachement function) and
2. After clicking the submit button, click another button (Issue another
form) that clears the completed form and start all over again or opens the
same form to be filled out.

Thanks a lot.
Maynard

Actually, the text box doesn't have to be in the footer. It can be anywhere
on your form
Sorry about that...
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[JerryTh [MSFT]]

You can't do this using the E-mail subnmit adapter.
This will involve scripting and I am not sure how do what you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

Thanks Jerry. I do have another question aside from calculation. In adding a
submit button, I know how to send or route it to a particular person via
e-mail. What I want to know is how to program the submit button by:

1. Sending it via e-mail with a blank To: CC: Bcc: (it's like an automatic
Send as attachement function) and
2. After clicking the submit button, click another button (Issue another
form) that clears the completed form and start all over again or opens the
same form to be filled out.

Thanks a lot.
Maynard

Actually, the text box doesn't have to be in the footer. It can be anywhere
on your form
Sorry about that...
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only


:

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[Maynard]

I see. I'm not familiar with Microsoft Script Editor so I'll just use the 1 -
2 click in sending the form via attachment. Thats alright. Thanks a lot!

You can't do this using the E-mail subnmit adapter.
This will involve scripting and I am not sure how do what you want.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

Thanks Jerry. I do have another question aside from calculation. In adding a
submit button, I know how to send or route it to a particular person via
e-mail. What I want to know is how to program the submit button by:

1. Sending it via e-mail with a blank To: CC: Bcc: (it's like an automatic
Send as attachement function) and
2. After clicking the submit button, click another button (Issue another
form) that clears the completed form and start all over again or opens the
same form to be filled out.

Thanks a lot.
Maynard

Actually, the text box doesn't have to be in the footer. It can be anywhere
on your form
Sorry about that...
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only


:

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only


:

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.

 

[LTAN]

Hi Jerry,

my problem right now is similar to this. i hope you could also help me. i
have a repeating table with 5 columns (COURSEDESC, DURATION, COURSEFEE, NO.
OF PARTICIPANTS AND TOTAL FEE) I've added footers to insert additional
items(ALLOWANCE, TRANSPORTATION, MISC.) At the end of the table, i have a
textbox for GRANDTOTAL. It works if i only have one entry but since it is a
repeating table, everytime, i insert another item, the total fee for the new
item is not summed up in the GRANDTOTAL, maybe because what i wrote in the
formula is TOTALFEE+ALLOWANCE+TRANSPORTATION+MISC. So when i insert another
item, it didnt read the additional item. i dont know how to configure this.
any help will be appreciated. thanks a lot.

When you get to step (Expand Data Source), you should see
[+]Group1 (or whatyever your group is named)

Clicking on the + will show you you
[-]Group1
[+]Group2

Clicking again will show you
[-]Group1
[-]Group1
income1
income2
income3
subtotral

I am guessing that your subtotal may be an Expression box. They are not
bound to a node in the Data Source, they are to show data.
If that is the case, then your Total expresion could be done like:
sum(income1)+sum(income2)+sum(income3)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only

Thanks Jerry.

Here's what I did.

1. I have a repeating table with one row ( income 1, income 2, income 3)
then a subtotal at the end of the row.
2. Followed your steps from 1 to 5.
3. Can't find/see my subtotal. How do I expand my data source?

1. In the footer of the table insert a Text box.
2. Open the properties of the Text box and select the Function button to the
right of the 'Value' field.
3. [Insert Function]
4. Select 'Sum', [OK]
5. Double click where it syas "Double click to insert field"
6. Expand the Groups until you see the field you want to total (ie "SubTotal")
The formula should be "sum(SubTotal)" (or whatever you named the subtotal
field)

If you just want to display the data for the user and printing but dont need
to store the value, use an Expression box instead.

Does that work for you?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Sample code subject to http://www.microsoft.com/info/cpyright.htm
Do not send email to this alias. It is for newsgroup only


:

I'm successful in adding values in a row but I'm stuck in adding the total
values of those rows in a repeating table. I wanted to have a subtotal then
get the over all total. Please help.