Calculating subtotals/page totals

Is this an LCD form?

Something like this might work for you...

var qtyOne = this.getField("Quantity Field Row 1 Name").value;
var qtyTwo = this.getField("Quantity Field Row 2 Name").value;
var qtyThree = this.getField("Quantity Field Row 3 Name").value;
var valOne = this.getField("Value Field Row 1 Name").value;
var valTwo = this.getField("Value Field Row 2 Name").value;
var valThree = this.getField("Value Field Row 3 Name").value;
var totalOne = this.getField("Total Field Row 1 Name").value;
var totalTwo = this.getField("Total Field Row 2 Name").value;
var totalThree = this.getField("Total Field Row 3 Name").value;
if (qtyOne != ""){
totalOne = (qtyOne * valOne);
event.value = totalOne;
}
if (qtyTwo != ""){
totalTwo = (qtyTwo * valTwo);
event.value = totalTwo;
}
if (qtyThree != ""){
totalThree = (qtyThree * valThree);
event.value = totalThree;
}

try67​ Yes, it is a LiveCycle form. Sorry, I should have put that in the description. It has the ability to add repeating rows to the table in the screenshot (see the plus/minus buttons to the right of each row).

subieguy2​ thanks for the suggestion. I see this is in AcroForm but it shouldn't be all that hard for me to translate to LiveCycle JavaScript (I've done it before with other code). I appreciate it. I figure it's something that I'm missing that's not clearing the row subtotal when a new row is created. Everything else seems to be working fine, so maybe this will help. I'll keep you posted. Thanks

I moved your question to the LiveCycle Designer forum.

try67​ ok, thanks.

How does the structure of you table look like? Please upload you form or post at least some screenshots.

Thanks radzmar​. Here's the layout (if necessary) and the structure (hierarchy) for the form as I have it. I would post the code that I have in the Total Value cell at the moment but I've modified it and switched it around so much trying different things, I'm not sure if I should... LOL

Layout:

Hierarchy:

I can't post this particular form but let me know if there's anything else that I can supply that you can use to help me figure this out.

I really appreciate everything.

Thanks. Yeah, the basic calculation is scripted in FormCalc and works fine. It's when a row has been calculated and then the user needs to add another row to fill in more data in the table, the subtotal from the previous row is then duplicated to the new row (see screenshot below).

In this example, the subtotal for the first row ($25) has been duplicated down through rows 2 and 3 despite the Quantity and Value columns containing differing values. Even if the values for Quantity and Value are blank, the Total Value column duplicates the value to the new row. Something tells me I need a script at the click event of the "Add Row" (i.e., '+' button) to clear the Total Value column for the next row when it's clicked. I also thought for a second that maybe that event could clear the Quantity or Value columns because apparently, one of those columns triggers the calculation in the Total Value column (Total Value column is blank until a number is entered in both Quantity and Value) but alas, could not solve the problem.

I managed to get the problematic page from the form up on DropBox:

https://www.dropbox.com/s/i6afbcuxuws376x/loanrequest_111318a.pdf?dl=0

Let me know if you don't have access to it.

Thanks again!