https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/119945.aspxFri, 12 Oct 2018 12:06:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119945Heste0https://www.infopathdev.com:443/forums/thread/119945.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119945Awesome - it works perfectly!! Thank you so much Hilaryhttps://www.infopathdev.com:443/forums/thread/119943.aspxThu, 11 Oct 2018 14:41:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119943Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119943.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119943Ah- that is because the total field being used for the sum function was not from the secondary data source (I think). Try this.https://www.infopathdev.com:443/forums/thread/119940.aspxThu, 11 Oct 2018 05:20:19 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119940Heste0https://www.infopathdev.com:443/forums/thread/119940.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119940Thank 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.)https://www.infopathdev.com:443/forums/thread/119939.aspxWed, 10 Oct 2018 17:12:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119939Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119939.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119939Try this one.https://www.infopathdev.com:443/forums/thread/119936.aspxWed, 10 Oct 2018 10:45:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119936Heste0https://www.infopathdev.com:443/forums/thread/119936.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119936Hi 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.https://www.infopathdev.com:443/forums/thread/119934.aspxTue, 09 Oct 2018 14:56:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119934Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119934.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119934Any 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.https://www.infopathdev.com:443/forums/thread/119932.aspxTue, 09 Oct 2018 07:43:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119932Heste0https://www.infopathdev.com:443/forums/thread/119932.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119932Thanks 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"])https://www.infopathdev.com:443/forums/thread/119927.aspxMon, 08 Oct 2018 15:05:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119927Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119927.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119927I'm wondering if this sample form might not help you: http://www.infopathdev.com/files/folders/examples/entry41116.aspxhttps://www.infopathdev.com:443/forums/thread/119912.aspxThu, 04 Oct 2018 10:28:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119912Heste0https://www.infopathdev.com:443/forums/thread/119912.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=119912I 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 :-)