Summarising/Totalling Columns

[Markos]

I'm new to Infopath and need to know if the following is possible and
some guidence on how to do it.....

I'm creating a timesheet to record each job I complete for a company
and what cost center within that company to charge to. I then need to
have a summary of the weeks work for each comany and cost center in a
table to present to Payroll. I have gotten as far as using a
repesting table to add a new line for each job but can't work out how
to group then summarise the time.
Also, can you have a dropdown selection within a repeating table?

 

[JerryTh [MSFT]]

Drop Down list boxes are perfectly happy in a Repeating Table.


You can put summary field in the table footer or outside of table altogether.
Add a function to text box.
Insert Function = 'Sum' and then select the column you want totaled.
You will need to do your time calculations in script. The built in functions
don't handle times and dates very well.