https://www.infopathdev.com:443/forums/142.aspxAre you exploring new features coming up in 2010? Share information and ask questions here!enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/81932.aspxFri, 24 Aug 2012 07:26:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81932Jimmy0https://www.infopathdev.com:443/forums/thread/81932.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81932So are you saying that some rows have flat amounts, and other rows have per-hour amounts?&nbsp; Do you have the Total Hours column displaying the expected amount in both cases?https://www.infopathdev.com:443/forums/thread/81927.aspxFri, 24 Aug 2012 01:11:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81927jasonwhitestl0https://www.infopathdev.com:443/forums/thread/81927.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81927I&#39;m using it in a default value formula Functionally it works, but I think there is room for improvement. It calculates the sum of all of the text boxes, so if there is only an amount on one row, and not amount * hours, the result will be off.https://www.infopathdev.com:443/forums/thread/81916.aspxThu, 23 Aug 2012 19:19:45 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81916jasonwhitestl0https://www.infopathdev.com:443/forums/thread/81916.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81916I just answered my own question The solution was to use the following formula sum(PreliminaryLineAndGradeAmount) * sum(PreliminaryLineAndGradeHoursUnits)https://www.infopathdev.com:443/forums/thread/81914.aspxThu, 23 Aug 2012 19:03:32 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81914Jimmy0https://www.infopathdev.com:443/forums/thread/81914.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81914Are you using it in a rule, or in a default value formula?https://www.infopathdev.com:443/forums/thread/81910.aspxThu, 23 Aug 2012 18:23:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81910jasonwhitestl0https://www.infopathdev.com:443/forums/thread/81910.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81910I&#39;m using the formula on the PreliminaryLineAndGradeTotalHours field I started with this formula &quot;sum(PreliminaryLineAndGradeTotalHours)&quot;, but the value always remained zero, regardless of how many rows I had entered. Thanks, Jasonhttps://www.infopathdev.com:443/forums/thread/81909.aspxThu, 23 Aug 2012 18:16:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81909Jimmy0https://www.infopathdev.com:443/forums/thread/81909.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81909<p>Hello Jason,</p><p>Where are you using that formula?&nbsp; If you already have a PreliminaryLineAndGradeTotalHours field, perhaps it would make more sense to just sum that.&nbsp; Is there a reason you&#39;re not doing that?</p>https://www.infopathdev.com:443/forums/thread/81904.aspxThu, 23 Aug 2012 16:51:25 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:81904jasonwhitestl0https://www.infopathdev.com:443/forums/thread/81904.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=142&PostID=81904I have a repeating table within a section, and a calculated field that multiplies the values of the Amount and Hours fields. I am attempting to create another field in the footer of the repeating table that sums up all of the values of the calculated field, but the value remains at zero. I have attached a screenshot of my configuration Thanks, jason