Naming calculated numeric fields, series calculations?

[Former Community Member]

I don't know why it's not working, but I'm having a lot of trouble getting what should be simple calculations to work on Adobe LiveCycle Designer (using v 8.2.1 on Windows XP).  Maybe I'm not entering the correct command in JavaScript.  Here's what I'm doing:

I create a numeric field on the form, then go into the Binding tab and name it "FieldA."

Now I create a table, and set the first cell as a numeric.  I go into the Java Window, Show Calculate, and type:

FieldA / 100

This returns the correct value without a problem.  I then set the name of this calculated cell as "Calc1" on the Binding tab.

I then try to set the value of the second cell, as above (from the Java Window) to be

FieldA - Calc1

However, I'm getting an error message saying that "Calc1 accessor is  unknown"

What is my mistake here?

[Former Community Member]

Sorry, I misread at first. If it's in another row, you may need to add the row identifier.

Message was edited by: westlakejager

[Former Community Member]

It is in a different row.  I'm not really good with JavaScript, but the Calc1 is in Row 2, and Calc2 (the result I'm looking for) is in Row 3 of the table.

How would I set the correct command?

[Former Community Member · Accepted solution]

Depending on the name of the row, the following should do it:

Row2.FieldA - Row2.Calc1

[Former Community Member]

That's it.  Thanks very much!