VERY simple calculation - "Script Failed" Value Unknown

[Former Community Member]

Greetings People. I am not new to LCD (I have been using this product for some time to create graphic documents), how-ever I am new to using LCD to create documents that do mathematical calculations...which is exactly why I am having this issue. Grrrrrrr sorry...

I have a simple document with a few tables/rows. Each row has a simple condition value (if something is checked there is a numeric value), this works great. What I am trying to do is just total the value of all the rows in each table, and that bombs (errors) with "Script Failed (language is formcalc; context is..) and then identifies all the fields names as "Unknown". I am tried testing a few different way and I always get this error, in fact I can't seem to get this form to just add to simple numbers without a similar error.

Note. I am sure this is me - just being less-than-smart, I don't belive there is a error with LCD itself.

Any direction would be most appreciated. Thanks VERY much!

http://www.chnwi.info/test/wellness_scorecard_final.pdf

[Former Community Member · Accepted solution]

Couple of things:

1. The sum command has capital S so it is Sum() not sum()

2. There is no space between Sum and the (

3. When you reference the other fields they are in a different subform than the total, so you must path to the fields. The easiest way to do this is in the Script Editor put the cursor where you want the reference to appear, then hold ctrl down and  move the cursor to the desired field. The cursor will change to a V. Release the mouse when you are on the field and the correct reference will be written into the script editor.

4. You cannot split the command across two lines ...keep it all on one line.

I have included my modified version. I only did the 1st table.

Paul

[Former Community Member]

WOW! You nailed it...and gave me a solid quick education. Thanks, everything is perfect.