Grand Totals not updating

[BajanPOET]

I have a repeating section where I calculate sub totals (Col1 * Col2 = Col3) I would like to create a grand total in my form (Expression sum(Col3)) that is not a part of my repeating section. The problem is that my grand total does not update, although my subtotals are updated as I enter more info into the repeating table.

GOD is in charge, though men may say, "Not so!

 

[BajanPOET]

I am trying to do a line item for a requisition form, so I am trying to achieve this: SubTotal = Qty * Unit Price in a repeating section (which works when I enter Qty and Unit Price, as well as summing up the one or more subtotals in a Grand Total.

I put the Grand Total field into the footer of the repeating section.

I realized that the Grand Total code (sum(SubTotal)) works if I temporarily move it to a field that I enter an entry for - like Qty. What event fires when an expression box is changed via a formula like SubTotal = Qty * Unit Price? Is there an OnChange event that I can programmatically call?

GOD is in charge, though men may say, "Not so!

 

[BajanPOET]

I figured it out.... I placed the update code (that calculates the Grand Total (sum(SubTotal)) as a Rule that executes whenever the Sub-Total is changed and then changed the Textbox into an expression box to see if the rule still held - and it did.



GOD is in charge, though men may say, "Not so!