https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3465.aspxThu, 09 Nov 2006 16:05:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3465Michael710https://www.infopathdev.com:443/forums/thread/3465.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3465I've tried to edit the Xpath to get it to query, but this Xpath has errors. with the child operator. Can someone help me out here.<br /><br /><br />(/myFields/datafields/d:TOSS/@employeeDepartment( =) '5201') sum(../@monthlyExpenses)https://www.infopathdev.com:443/forums/thread/1656.aspxThu, 09 Nov 2006 14:46:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1656Michael710https://www.infopathdev.com:443/forums/thread/1656.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1656How do I total a columns in InfoPath depending on a field (department) using C# or jscript or VBscript in InfoPath. The user will select a <b>department</b> from a drop down box on a InfoPath Form, and automaticly in the totals repeating table on the form it will select the monthlyExpenses and monthlyBudgeted and total them up for the year. Everytime the user selects a different department, the totals will be addded for the year for that department. The department drop down box will all so be connected to a submit data connection. If it is a easier way using rules let me know. Thanks.<br /><br /><b>Please help</b>