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

SOLVED

VERY simple calculation - "Script Failed" Value Unknown

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 1

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