JavaScript to Evaluate Value in an Array of Cells

[ArrueiraVermelh]

Hi There,

I am working on a pricing table in an ordering form. I need to show a subform if any row has a subtotal above 2,000. I was able to get that script going except that when the "add row" is clicked the subform is hidden again no matter which subtotals values I have in that column. Another issue is that when edits are made to quantity and unit price the subtotal is not updating. The " delete row"  option doesn't seem to affect the script negatively. How can I get "Add row"  to correctly evaluate if any subtotal cell in the table is above or below 2,000 and show/hide the subform accordingly. And why is my calculation no updating when I change  actual and qty values?

Thanks in advance for any help!

Here is what I have:

Script in Calculate event of the subtotal (extended) cell:

if ( actual.rawValue != null || qty.rawValue != null) {
this.rawValue = actual.rawValue * qty.rawValue;
}
checkValues.compAnalysis()

Function:

function compAnalysis() {
var oFields = xfa.resolveNodes("PRForm.orderDetails.orderTable.orderLine[*].extended[*]"); 
var nNodesLength = oFields.length; 
for (var nNodeCount = 0; nNodeCount < nNodesLength; nNodeCount++) {     
nLineTotal = oFields.item(nNodeCount).rawValue; 
if ( nLineTotal != null && nLineTotal >= 2000 ) {
      this.resolveNode("H-comparativeBids").presence = "visible";
      this.resolveNode("H-comparativeBids.justification").validate.nullTest = "error";
      } 
    else if ( nLineTotal == null || nLineTotal <= 2000 ) {
          this.resolveNode("H-comparativeBids").presence = "hidden";
          this.resolveNode("H-comparativeBids.justification").validate.nullTest = "disabled";
          }
    }
}