InfoPath Dev

I 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

Hello Jason,

Where are you using that formula?  If you already have a PreliminaryLineAndGradeTotalHours field, perhaps it would make more sense to just sum that.  Is there a reason you're not doing that?

I'm using the formula on the PreliminaryLineAndGradeTotalHours field I started with this formula "sum(PreliminaryLineAndGradeTotalHours)", but the value always remained zero, regardless of how many rows I had entered. Thanks, Jason

Are you using it in a rule, or in a default value formula?

I just answered my own question The solution was to use the following formula sum(PreliminaryLineAndGradeAmount) * sum(PreliminaryLineAndGradeHoursUnits)

I'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.

So are you saying that some rows have flat amounts, and other rows have per-hour amounts?  Do you have the Total Hours column displaying the expected amount in both cases?