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/91513.aspxSun, 21 Jul 2013 00:24:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91513Patrick Halstead0https://www.infopathdev.com:443/forums/thread/91513.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=91513<p>you can add a calculated value with an Fx function of sum(TotalHours) where field is filtered by the dropdown list.</p> <p>attaching a sample for your survival</p> <p>&nbsp;</p>https://www.infopathdev.com:443/forums/thread/91505.aspxFri, 19 Jul 2013 22:16:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:91505deeprambo0https://www.infopathdev.com:443/forums/thread/91505.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=91505<p>I have a repeating table with the following fields. Date, StartTime, EndTime, TotalHours, RegOrOT (dropdownlist).&nbsp; THe drop downlist has 2 options.. Regular and Overtime.</p><p> In the footer I have two fields (Regular hours total and Overtime hours total)&nbsp; </p><p>I want to sum the value of all the Regular TotalHours in one&nbsp; field and Overtime Hours in another feild.&nbsp; How can this I achieve this?<br /></p>