Subtotaling across a row

[Steve Reichgut]

I have a quick question regarding subtotaling. I am trying
to create a timesheet form for my employees. I figured out
how to subtotal down a column (i.e. all tasks on Monday)
but cannot figure out how to subtotal across a row (i.e. a
specific task for the whole week).

Can someone help me out and tell me how to do this. Thanks!

Steve

 

[Jerry Thomas [MSFT]]

In your row subtotal column, you can use a Text Box if you want the data
stored or an Expression Box if you just want to display the information.

For a Text Box, open the "Text Box Properties" (right click on the control)
Set the data type to Integer or Double (depending on what the other felds
are)
For the "Value" field, select the "Fx" button
Insert the fields and '+' symbols to add the ones you want: field1 +
field2 + field3

Now you get
Task1 Task2 Task3 Total
1.0 2.5 1.5 5.0
--
Jerry Thomas
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.