InfoPath Dev

I have an infopath form developed on a list with a repeating table. The form have 2 data connections to the same list. (one is secondary) It is build for a budget. You select the project number, and the different expenses for that project is displayed. Then you can add another expense. The expenses (Item column) is in different groups, Resources, Consultants, Travel, ect. A thrid datasource retreive the resources from the resource list that contains their rate per hour. I'm having trouble with 2 items on the form: 1. I need to subtotal all the different type of expenses, all expenses are listed in the budget's repeating table and at the bottom I have 3 lines for Subtotal - Resources, Subtotal - Consultants and Subtotal - Travel. How do I calculate those fields, in other words I need to sum all amounts where item=resources, ect? 2. When I select resource from the item column, the data connection to the resource list should query the resource list and in the designation field populate the different designations, and based on the selected designation, populate the hourly tariff field. How do I accomplish that? Your help will be much appreciated :-)

I'm wondering if this sample form might not help you: http://www.infopathdev.com/files/folders/examples/entry41116.aspx

Thanks Hillary, but my problem is, the list is a repeating table and the Item Type is a lookup field. When I enter the fx function, it returns '0' although there are items in the Item Type column/field. This is how my fx looks like: sum(Total[Item = "Resources"])

Any chance I can see your form? You can attach it under Options in a reply.... my guess is that the actual value for "Item" is going to be an ID, not a text value.... since it's a lookup. You may have to get the ID from the secondary data source providing the values to the lookup.

Hi Hillary, here's my form. You're right, it should change to the ID, and the ID for 'Resources' is 5. You'll see on the form next to 'Resources' a calculated field, that is where I'm trying to add the totals where Item Type = Resources. I need to repeat that for all the Reimbursables and sub consultants as well. But if you can guide me on the correct formula to use, I can do it for the others.

Try this one.

Thank you Hillary, it seems we're on the track to the solution. But it only shows the sum of the current 'Resources' field you're in, it does not show the sum of all Totals where all Item Types = Resources. (I use Job No 3 for testing, it has 3 resources.)

Ah- that is because the total field being used for the sum function was not from the secondary data source (I think). Try this.

Awesome - it works perfectly!! Thank you so much Hilary