Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Using FormCalc in Adobe Live Cycle

Avatar

Not applicable
I am trying to do some simple calculations in a table in Adobe LiveCycle Designer and I cannot figure out what I am doing wrong.



I have created a TABLE (Table 1), and can identify the names of the cells.



I am trying to add Row1.Cell3 and Row1.Cell4 together in a subtotal column-- which happens to be Row1.Cell5. I need to do that for several rows but can't get it to work for the first one.



Then, I need to add All the Row 5 subtotal values together. (Row1.Cell 5, Row2.Cell5, Row3.Cell5, etc.)



I have tried using the help system and the advice of another person who said to use:

sum(row1.cell3,row1.cell4)

He told me to use this instead of the suggested FormCalc forumla I found in help (which I also could not get to work) because I was using a table.



It doesn't work and gives me the message:

Error: Accessor 'row1.cell3' is unknown



I am stumped. Can anyone help me? It seems like it should be simple, but it hasn't been.
1 Reply

Avatar

Level 2

Make sure you are using the same cases.  Row1.Cell1 is different from row1.cell1.