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

Calculated Field Problem

Avatar

Level 1

I am designing an order form and this is my first time using livecycle. I have 2 tables each with 10 drop down boxes of varying items. Followed by a unit price, quantity and total.

All of these boxes work correctly.

I am having problems calculating the total at the bottom for all the boxes.

I have tried

Sum(Table1.Row1.tptw1, Table1.Row2.tptw2); and so on. I get an error accessor in unknown

I have tried to make a hidden columnm, however I cannot get it to remain totally invisible.

I am know basically nothing about javascript which I am sure is what is needed.

Any help would be great

0 Replies

Avatar

Level 7

You can use FormCalc instead of Javascript and either do:

$ = Table1.Row1.tptw1 + Table1.Row2.tptw2 + etc

or you can name all the rows and the cells with the number the same thing (ie. call them all Row1 and then it will automatically make it Row1[0], Row1[1], etc and do the same with the cell) and them just do

$ = Sum(Row1[*].tptw)