Expand my Community achievements bar.

Summing Table Column - backwards compability between v9 and v7 (FormCalc)

Avatar

Level 2

The following FormCalc is working fine in the form that I'm designing when the Reader version is 9:

Sum(table1.row[*].Cell3)

However, I have to make the form backwards compatible with Reader 7 and when I run the form in Reader 7, FormCalc hiccupps and reports that

"Error:  SOM expression returned list when single result expected."

(a) is there a difference between the way FormCalc handles this expression between versions 7 and 9?

(b)     I get the same error for the expresson Sum(xfa.form.resolveNode(form1.table1.row[*].Cell3)).

Is there another way to do this?  The users can add instances of the rows so I can't hard code in the row count.

Thanks in advance!

2 Replies

Avatar

Level 10

Hi,

Try Sum(table1.row[*].Cell3[*])

Hope that works,

N.

Avatar

Level 2

Yup, that worked perfectly.  Thanks!